MySQL之获取上下一条记录

/*获取指定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