MySQL语句执行顺序和编写顺序实例解析

select语句完整语法： SELECT DISTINCT &lt;select_list&gt; FROM <left> <join> JOIN <right> ON <join> WHERE <where> GROUP BY <group> HAVING <having> ORDER BY <order> LIMIT <limit> 执行顺序： from →join →on →where →group by→having→select→order