MySQL语句书写顺序、执行顺序

sql语句书写顺序

  SELECT ...        -----------------------> 在查询结果中显示的列
  FROM ...          -----------------------> 查询哪张表
       JOIN ...     -----------------------> 与哪张表连接
            ON  ... -----------------------> 指定连接条件
  WHERE ...         -----------------------> 过滤数据
  GROUP BY ...      -----------------------> 根据哪些条件分组
  HAVING ...        -----------------------> 对分组后的数据再筛选
  ORDER BY ...      -----------------------> 指定排序条件

sql 语句的执行顺序

1. FROM ...
2. JOIN ... ON ...
3. WHERE ...
4. GROUP BY ...
5. HAVING ...
6. SELECT ...
7. ORDER BY ...