select
FIELDS... //列筛选
from
TABLENAME //从那张表中筛选
where //行筛选(条件)
...
group by //分组
FIELDS... //左1位为主,其右依次为辅 ,以逗号分隔
having
... //分组结果二次筛选
order by
[FIELD ASC(升序,默认)/DESC(降序)]...
limit //分页展示 当前页码:pageNo,每页的数据量:pageSize,总页数:total
(pageNo-1)*pageSize,pageSize;
本文地址:https://blog.csdn.net/zzzinsser/article/details/107141479
如对本文有疑问, 点击进行留言回复!!
数据库优化-索引的创建-MySQL-index-SQL优化-避免全表扫描
网友评论