Question

如何在mysql中查询当前数据上一条和下一条的记录

Answer 1

select * from table_a where id = (select id from table_a where id > {$id} [and other_conditions] order by id asc limit 1) [and other_conditions];//先把上一条主键和下一条主键查出来。