开发笔记:mysqlorderbylimit使用注意事项

--查看mysql版本
select version()
--创建表
create table student(
id int(10) PRIMARY KEY auto_increment,
name varchar(32),
age int(3)
)
--插入数据
insert into student VALUEs(null,\'小明\',11);
insert into student VALUEs(null,\'王小明\',5);
insert into student VALUEs(null,\'小二毛\',11);
insert into student VALUEs(null,\'王小三\',4);
insert into student VALUEs(null,\'毛小二\',11);
insert into student VALUEs(null,\'张小二\',11);
--插入表
select * from student s
order by age desc
--分页查询
select * from(select * from student s
order by age desc LIMIT 0,1)tab
union all
select * from(select * from student s
order by age desc LIMIT 1,1)tab
union all
select * from(select * from student s
order by age desc LIMIT 2,1)tab
UNION ALL
select * from(select * from student s
order by age desc LIMIT 3,1)tab

--分页查询
select * from(select * from student s
order by age desc,id asc LIMIT 0,1)tab
union all
select * from(select * from student s
order by age desc,id asc LIMIT 1,1)tab
union all
select * from(select * from student s
order by age desc,id asc LIMIT 2,1)tab
UNION ALL
select * from(select * from student s
order by age desc,id asc LIMIT 3,1)tab

select * from `cpn_coupon_code` c limit 10000000,10

SELECT * FROM cpn_coupon_code c
INNER JOIN (SELECT id FROM cpn_coupon_code e LIMIT 10000000,10)tab on tab.id=c.id