mysql学习笔记

一、查询处理

1.1 逻辑查询处理

     逻辑查询处理的顺序及步骤

    (8) select   (9) DISTINCT<selectlist>

   (1) from   <left_table>

   (3) <join_type> JOIN <right_table>

   (2) ON  <join_condition>

   (4) WHERE <where_conition>

   (5) GROUP BY<group_by_list>

    (6) WITH {CUBE | ROLLUP}

    (7) HAVING <having_conition>

    (10) ORDER BY <order_by_list>

    (11) LIMIT <limit_number>