MYSQL 取上一条记录,与下一条记录

$id为当前ID，仅供参考：

SELECT*FROMtableWHEREid>$idORDERBYidASCLIMIT1

SELECT*FROMtableWHEREid<$idORDERbyidDESCLIMIT1

$id=0

select*fromtableorderbyiddesclimit1;

$id>max

select*fromtablelimit1,

转载于:https://blog.51cto.com/excelsior/1298363