mysql查詢處理順序

標籤：blog   http   io   sp   div   on   log   bs   ef   

http://zhangzhaoaaa.iteye.com/blog/1689412參考：《MYSQL技術內幕SQL編程》

select distinct <selectlist>

from lefttable

<join-type>join <righttable>

on <join_condition>

where<where_condition>

group by<groupbylist>

with{CUBE|ROLLUP}

HAVING<havingcondition>

order by<orderbylist>

limit<limitnumber>

處理順序

 

1. from
2. on
3. join
4. where
5. group by
6. cube|rollup
7. having
8. select
9. distinct
10. order by
11. limit

mysql查詢處理順序