MySQL技术编程内幕——逻辑查询处理的步骤序号

来源:互联网 发布:表删除数据 sql 编辑:程序博客网 时间:2024/06/07 04:06

我怕有一天找不到 记下来


(8) SELECT (9) DISTINCT <select_list>

(1) FROM <left_table>

(3) <join type> JOIN <right_table>

(2)                     ON <join_condition>

(4) WHERE <where_condition>

(5) GROUP BY <group_by_list>

(6) WITH {CUBE | ROLLUP}

(7) HAVING <having_condition>

(10) ORDER BY <order_by_list>

(11) LIMIT <limit_number>