MySQL基本语法复习
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>
七种JOIN要会写
下一篇
MySQL知识点总结(二)MySQL架构与事务基础