Mysql用select查询文章ID的上一篇和下一篇的方法！

/* 方式1： 获取给出id 的上一条，下一条 */select * from t_article where id = (select id from t_article where id < 4 order by id desc limit 1); select * from t_arti...