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

最新推荐文章于 2024-02-28 12:09:49 发布

木木-木

最新推荐文章于 2024-02-28 12:09:49 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： MySQL 文章标签： mysql

原文链接：https://blog.csdn.net/weixin_42394137/article/details/112672415

MySQL 专栏收录该内容

6 篇文章

订阅专栏

转载地址

下一条

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

上一条

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