Mysql执行顺序

mysql语法顺序：
select from join on where group by having union order by limit

mysql执行顺序：
from
on
join
where
group by
having
select
distinct
order by
limit

参考一叶扁舟-MySql语句执行顺序，请移步。