分页sql
来源:互联网 发布:mac mkv 免费播放器 编辑:程序博客网 时间:2024/06/08 07:11
正常分页
LIMIT #offset#, #pageSize#select * from sop_project_base order by id limit 1052,200
游标分页
WHERE cursor > #cursor# LIMIT #pageSize#select * from sop_project_base where id>1052 order by id limit 20
缓存子查询
SELECT * FROM `crm_account_info` WHERE id > (SELECT id FROM `crm_account_info` WHERE type=0 ORDER BY id LIMIT 899999,1) ORDER BY id LIMIT 10;SELECT * FROM `crm_account_info` WHERE type=0 ORDER BY id LIMIT 899990,10;
覆盖索引
SELECT * FROM crm_account_info AS a, (SELECT id FROM `crm_account_info` WHERE type=0 ORDER BY id LIMIT 900000,10) AS b WHERE a.id =b.id ;
反向查询
$ = SELECT count(1) FROM `crm_account_info` ;SELECT * FROM `crm_account_info` WHERE type=0 ORDER BY id desc LIMIT ($-9), 10;
阅读全文
0 0
- Sql 分页
- SQL 分页
- sql分页
- sql分页
- sql分页
- sql分页
- SQL分页
- SQL分页
- sql分页
- sql 分页
- SQL分页
- SQL分页
- sql 分页
- 分页SQL
- SQL分页
- sql 分页
- sql分页
- 分页SQL
- RDS的MySQL备份还原
- 国内9大免费CDN汇总,除了加速乐,你还用过哪些?
- 使用matplotlib画散点图/连线图/直方图
- zzuli 2177
- Android 图片自动轮播
- 分页sql
- HP Diagnostics惹的祸
- idea 安装和破解
- 一个 Q-learning 算法的简明教程
- 20170822日记账流水(2017-08-22 10:00)
- Quick steps to remove nodes from cluster
- 使用Aircrack-ng工具破解WEP、WPA/WPA2加密的无线网络
- 看板和项目缺陷管理
- php数据查询的时候字符串变量要加引号