Mysql 上一条 下一条记录

方法一:

SELECT * FROM table_name WHERE id IN (
SELECT CASE 
	WHEN SIGN(id - 8) > 0 
		THEN MIN(id) 
	WHEN SIGN(id - 8) < 0 
		THEN MAX(id) END AS id
FROM table_name WHERE id <> 8 GROUP BY SIGN(id - 8) ORDER BY SIGN(id - 8)
) ORDER BY id ASC; 

方法二:
上一条：

SELECT * FROM table_name WHERE id < $id ORDER BY id DESC LIMIT 1 

下一条：

SELECT * FROM table_name WHERE id > $id ORDER BY id ASC LIMIT 1