示例数据表:article
自增主键 :id
当前文章id:100
select
*
from
article
where
id<100
order
by
id
desc
limit 1; #上一篇
select
*
from
article
where
id>100 limit 1; #下一篇
示例数据表:article
自增主键 :id
当前文章id:100
select
*
from
article
where
id<100
order
by
id
desc
limit 1; #上一篇
select
*
from
article
where
id>100 limit 1; #下一篇