mc_otp_review_example为表名,id为表的主键(int类型)
查询上一条数据:
select * from mc_otp_review_example where
id=(select max(id) from mc_otp_review_example where id< 10)
查询下一条数据:
select * from mc_otp_review_example where
id=(select min(id) from mc_otp_review_example where id> 10)