MySQL中SQL语句的写法与读取顺序

一、SQL语句手写顺序

SELECT DISTINCT
    < Base_Column_List > 
FROM
    < left_table >
    JOIN < right_table > ON < join_condition > 
WHERE
    < where_condition > 
GROUP BY
    < group_list > 
HAVING
    < having_condition > 
ORDER BY
    < order_condition > 
    LIMIT < limit_num>

二、SQL语句程序读取顺序

1、FROM < left_table >    
2、ON < join_condition > 
3、JOIN < right_table > 
4、WHERE < where_condition > 
5、GROUP BY < group_list > 
6、HAVING < having_condition > 
7、SELECT
8、DISTINCT < Base_Column_List > 
9、ORDER BY < order_condition > 
10、LIMIT < limit_num>

三、SQL解析顺序

sql解析的顺序基本与程序读取顺序一致。