发布于
更新于
阅读:233
评论:0
MySQL之获取上下一条记录
1
2
3
4
5
/*获取指定id的上一条记录，我这里是以id=5为例的*/select cid,cname from company order by cid>=5,cid desc limit 1 /*获取指定id的下一条记录，我这里是以id=5为例的*/SELECT cid,cname from company order by cid<=5,cid asc limit 1