mysql数据库-分页查询

后端 / 2021-08-23

limit

select ... limit start,rows;
``

- start 开始位置 (start+1位置开始)
- rows 记录数量

## 分页公示
```mysql
select * from tableName
	group by XXX
	limit 显示记录数*(第几页-1),每页个数;

example

select *
from emp
order by empno
    limit 0,3;

# 第三页
select *
from emp
order by empno desc
    limit 10,5;


# 第五页
select *
from emp
order by empno desc
    limit 20,5;