分页方案
不让看,例如博客园
select
*
from
userinfo
where
userinfo.uid
in
(select uid from userinfo limit 700000, 10);
select * from userinfo where uid > 700000 / max_id limit 10;
select
*
from
(select * from userinfo where uid < 700001 / min_id order by uid desc limit 10) as ReversedLastPage
order by
ReversedLastPage.uid asc;
199 - 196 = 3
select
*
from
userinfo
where
userinfo.uid
in (
select
UID.uid
from
(select AmongData.uid from (select uid from userinfo where uid > 当前页最大值 limit 每页数据 * [页码-当前页])
as AmongData order by AmongData.uid desc limit 10) as UID order by UID.uid asc)
order by userinfo.uid asc;