SQL 语法整理[原创]

SQL 语句和执行顺序

Posted by David on December 17, 2019

前言

SQL 语句回顾

查询语句


SELECT  field, count(*) 
FROM  tableA
[INNER]|[FULL|LEFT|RIGHT|OUTER ]JOIN tableB #连接方式
ON     tableA.field = tableB.field #连接条件
WHERE  field >=< conditon #查询条件
GROUP BY   # 分组条件
HAVING     #分组过滤条件
ORDER BY  # 排序条件  ASC DESC
LIMIT

事务语句

START TRANSACTION
# MUTIL_SQL
COMMIT|ROLLBACK;

最后,给个 star 吧~