Mysql 语句编辑与执行顺序
SQL语句的编辑顺序
select [distinct]
from
join(如left join)
on
where
group by
having
union
order by
limit
SQL语句的执行顺序
from
on
join
where
group by
having
select
distinct
union
order by
join与where语句联合: 先执行join 形成笛卡尔积 然后再过滤 ????
having: 对group by的执行结果进行筛选,在group by 后执行