MySQL SQL 解析顺序

原创
2018/08/31 09:15
阅读数 549

人写的 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 >

 

机器读取 SQL 的顺序 :

1
FROM <left_table>

2
ON <join_condition>

3
<join_type> JOIN <right_table>

4
WHERE <where_condition>

5
GROUP BY <group_by_list>

6
HAVING <having_condition>

7
SELECT

8
DISTINCT <select_list>

9
ORDER BY <order_by_condition>

10
LIMIT <limit_number>

 

SQL 解析顺序 :

展开阅读全文
加载中
点击引领话题📣 发布并加入讨论🔥
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部