mysql分页查询

最新推荐文章于 2024-11-01 11:00:05 发布

黎上

最新推荐文章于 2024-11-01 11:00:05 发布

阅读量289

点赞数

文章标签： mysql 分页

本文链接：https://blog.csdn.net/u012132984/article/details/51638595

版权

创建一个表：

create table dept(
	deptno int(11) primary key,
	dname varchar(14),
	loc varchar(13)
);
insert into dept values (10,'A','A');
insert into dept values (20,'B','B');
insert into dept values (30,'C','C');
insert into dept values (40,'D','D');
insert into dept values (50,'E','E');
select * from [table] order by [element] desc limit 3,2; 
ex:select  *from dept order by deptno desc limit 3,2;</strong></span>