我們編寫的語句格式如下：

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的執(zhí)行順序如下：

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>

雖然，我們寫的SELECT語句在前，但是在MySQL的執(zhí)行順序中，首先執(zhí)行的FROM語句。
圖形方式展示如下：

MySQL的執(zhí)行順序