56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT A.* from TableA AS A
where id >=(SELECT id from TableA order by id desc limit 99,1) limit 100
SELECT A.* from TableA AS A
left join TableB as B on A.fid=B.fid
where B.fname ='$some' AND id >=(SELECT id from TableA order by id desc limit 99,1) limit 100
SELECT A.* from TableA AS A
left join TableB as B on A.fid=B.fid
where B.fname ='$some' AND id >=(SELECT id from TableA order by id desc limit 99,1) limit 100
这个结果不太对,
left join TableB as B on A.fid=B.fid
where B.fname ='$some'
加上这个,貌似是在100条里面筛选结果,这里我希望跟正常分页一样
SELECT A.* from TableA AS A
where id >=(SELECT id from TableA order by id desc limit $offset,1) limit $pagesize
这里的$offset=$page*$pagesize-1;
但是left join TableB as B on A.fid=B.fid where ..... 之后,结果的行数就不对了。
如果按照这个翻页算法。这个查询好像只在100条记录里面进行筛选。SELECT A.* from TableA AS A
where id >=(SELECT id from TableA order by id desc limit 99,1) limit 100
这个返回的是100条记录
SELECT A.* from TableA AS A
left join TableB as B on A.fid=B.fid
where B.fname ='$some' AND id >=(SELECT id from TableA order by id desc limit 99,1) limit 100
这个呢。返回的记录行数不正确。好像是最后一页记录。