-
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...
/* 方式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...