语法格式
select * from 表名 limit 起始索引 ,展示的记录数目;
create table student2 -- 创建学生表
(
id int comment '学号',
wokenumber varchar(12) comment '工号',
name varchar(9) comment '姓名',
xb char comment '性别',
age int comment '年龄',
idcard char(12) comment '身份证号',
wokedress varchar(20) comment '工作地址',
woketime date comment '工作时间'
)comment '员工表';
insert into student2 (id ,wokenumber,name,xb,age,idcard,wokedress,woketime)
values (1,'1','a','男',11,2142151207,'北京','2000-12-1'),
(2,'2','b','女',12,2142151208,'上海','2001-12-1'),
(3,'3','c','男',13,2142151209,'上海','2002-12-1'),
(4,'4','d','男',14,2142151201,'北京','2003-12-1'),
(5,'5','e','男',15,2142151202,'无为','2004-12-1'),
(6,'6','f','女',16,2142151203,'河北','2005-12-1'),
(7,'7','g','女',17,2142151204,'北京','2006-11-1'),
(8,'8','h','女',18,2142151205,'上海','2007-12-1');
insert into student2(id ,wokenumber,name,xb,age,idcard,wokedress,woketime)values (9,'9','g','男',20,null,'天津','2007-12-1');
insert into student2(id ,wokenumber,name,xb,age,idcard,wokedress,woketime)values (10,'8','宝宝','女',21,2142151209,'上海','2007-12-1');
insert into student2(id ,wokenumber,name,xb,age,idcard,wokedress,woketime)values (10,'8','傻狗X','男',21,2142151221,'上海','2007-12-1');
update student2 set age =20 where id=10;
-- 分页查询
-- 1 查询第一页学生数据,每页展示5条记录
select * from student2 limit 0,5;
select * from student2 limit 5; -- 第一页索引可以省去
-- 2 查询第二页学生数据,每页展示3条记录 (查询第一页后的起始索引是(页码-1)*页展示记录数)
select * from student2 limit 3,3;
-- 3 查询第三页学生数据,每页展示3条记录 (查询第一页后的起始索引是(页码-1)*页展示记录数)
select * from student2 limit 6,3; -- 从哪条记录位置开始查询 即起始索引是(页码-1)*页展示记录数,
-- (页码-1)*页展示记录数,计算的是即将要查询的起始位置即是id为6的位置,往后查询的三条记录
原图
结果 1
结果 2
结果 3