MySQL是会被机器进行重新优化的,并不是按照写的顺序一次执行的
语法顺序
select distinct
<select_list>
from
<left_table><join_type>
join <right_table> on <join_codition>
where
<where_condition>
group by
<group_by_list>
having
<having_condition>
order by
<order_by_condition>
limit <column_index,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_conditon>
limit <column_index,limit_number>