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

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

SELECT*FROMtableWHEREid>$idORDERBYidASCLIMIT1

SELECT*FROMtableWHEREid<$idORDERbyidDESCLIMIT1

$id=0

select*fromtableorderbyiddesclimit1;

$id>max

select*fromtablelimit1,