id作为自增int SQL语句如下即可:
上一条
SELECT * FROM A WHERE id < $id ORDER BY id DESC LIMIT 1
下一条
SELECT * FROM A WHERE id > $id ORDER BY id ASC LIMIT 1
id作为自增int SQL语句如下即可:
上一条
SELECT * FROM A WHERE id < $id ORDER BY id DESC LIMIT 1
下一条
SELECT * FROM A WHERE id > $id ORDER BY id ASC LIMIT 1