sql mysql 執行順序 (4)

峰下葉霜發表於2020-11-26

1.執行順序

(1) FROM <left_table> 
(2) <join_type> JOIN <right_table> 
(3) ON <join_condition> 
(4) WHERE <where_condition> 
(5) GROUP BY <group_by_list> 
(6) WITH {CUBE | ROLLUP} 
(7) HAVING <having_condition> 
(8) SELECT 
(9) DISTINCT 
(10) ORDER BY <order_by_list> 
(11) <TOP_specification> <select_list>

上一篇 sql mysql 檢視引擎 (3)

相關文章