MySQL---SQL执行加载顺序

我们程序员在手写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 >

而MySQL的对SQL的执行顺序是：

FROM < left_table >
ON < join_condition >
< join_type > JOIN < right_table >
WHERE < where_condition >
GROUP BY < group_by_list >
HAVING < having_condition >
SELECT
DISTINCT < select_list >
ORDER BY < order_by_condition >
LIMIT < limit_number >

---

资料来源于尚硅谷课程，记录学习的知识，后期有自己的理解与见解后再进行补充