mysql分页查询

创建一个表：

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>