July.Code's Blog

:: :: :: ::

[转] [MySQL]執行順序與效率概論

摘要： MySQL執行順序如下 1.FROM 2.ON 3.JOIN 4.WHERE 5.GROUP BY 6.WITH CUBEor WITH ROLLUP 7.HAVING 8.SELECT 9.DISTINCT 10.ORDER BY 11.TOP / LIMIT 阅读全文

posted @ 2012-11-13 16:44 |orz 阅读(303) 评论(0) 推荐(0) 编辑