mysql DQL执行语句的总结

1
2
3
4
5
6
7
8
9
10
11
12
select
			...
from
			...
where
			...
group by
			...
having
			...
order by
			...

第一:以上关键字的顺序不可以改变,严格遵守

第二:执行顺序

  1. from
  2. where
  3. group by
  4. having
  5. select
  6. order by