比如id=1000 前后的两个idmysql> (select id from succsms_back where id<1000 order by id desc limit 1)
-> union all
-> (select id from succsms_back where id>1000 order by id limit 1);
+------+
| id |
+------+
| 999 |
| 1001 |
+------+
2 rows in set (0.00 sec)
-> union all
-> (select id from succsms_back where id>1000 order by id limit 1);
+------+
| id |
+------+
| 999 |
| 1001 |
+------+
2 rows in set (0.00 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货