Mysql语句执行顺序
mysql中,sql语句执行也是要分顺序的哦,下面我就来为大家介绍一下。
且看样例:
select avg(s.age)
from student s
left join class c on s.class_id = c.id
where
c.name = '一班'
group by s.age
order by s.age
limit 100
语句的执行顺序如下:
(1)from
(2) join
(3) on
(4) where
(5)group by(开始使用select中的别名,后面的语句中均可以使用)
(6) avg,sum…
(7)having
(8) select
(9) distinct
(10) order by
(11) limit