MySQL高级开发–查询SQL执行顺序
标签(空格分隔): MySQL
在对SQL语句优化执行,需要明确一个普通的SQL在数据库服务器中从解析到执行,遵循一定的规则。
一、手工写一条SQL如下
SELECT DISTINCT
< select_list >
FROM
< left_table > < join_type >
JOIN <right_table> ON < join_condition>
WHERE
< where_condition >
GROUP BY
< group_by_list >
HAVING
< having_condition >
ORDER BY
<order_by_condition>
LIMIT <limit number>
二、机器解析
FROM
< left_table > < join_type >
JOIN <right_table> ON < join_condition>
WHERE
< where_condition >
GROUP BY
< group_by_list >
HAVING
< having_condition >
SELECT DISTINCT
< select_list >
ORDER BY
<order_by_condition>
LIMIT <limit number>