mysql 查询表中某条记录的上一条、下一条

 注意：如果有排序，则各个子查询中的排序相同

下一条：

select t1.*
from (
-- 查询数据添加序号列
 SELECT @num:=@num+1 AS rownum, holiday.* 
 FROM holiday,(SELECT @num:=0) as r 
 ORDER BY cr_date
)t1,(
-- 查询当前记录对应序号
  select curNum from(
		SELECT @num2:=@num2+1 AS curNum, holiday.* 
		FROM holiday ,(SELECT @num2:=0) r2
		ORDER BY cr_date
	)t
	where id=5014
)t2
where rownum > curNum
ORDER BY rownum
limit 1

上一条 ：

select t1.*
from (
-- 查询数据添加序号列
 SELECT @num:=@num+1 AS rownum, holiday.* 
 FROM holiday,(SELECT @num:=0) as r 
 ORDER BY date
)t1,(
-- 查询当前记录对应序号
  select curNum from(
		SELECT @num2:=@num2+1 AS curNum, holiday.* 
		FROM holiday ,(SELECT @num2:=0) r2
		ORDER BY date
	)t
	where id=5014
)t2
where rownum < curNum
ORDER BY rownum desc
limit 1