研磨Mysql之SQL的执行顺序

mac2022-06-30  18

手写顺序:

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>

电脑解释:

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>

最新回复(0)