常用SQL语句笔记

一、查询当前数据上一条和下一条的记录

# 第一种
1.select * from table_a where id = (select max(id) from table_a where id < {$id});   
2.select * from table_a where id = (select min(id) from table_a where id > {$id});
# 第二种
1.select * from table_a where id = (select id from table_a where id < {$id} order by id desc limit 1);   
2.select * from table_a where id = (select id from table_a where id > {$id} order by id asc limit 1);