SELECT `id` FROM `new_user_permit` WHERE `id` > 4 ORDER BY `transport_ymd` ASC,`created_at` ASC LIMIT 1;
SELECT `id` FROM `new_user_permit` WHERE `id` < 1 ORDER BY `transport_ymd` ASC,`created_at` ASC LIMIT 1;
上面的SQL在处理边界值时,SQL会报错,因此不是最佳的解决方案,所以目前使用的是下面的SQL:
SELECT MAX(id) AS tp_max FROM `new_user_permit` WHERE `id` < 1 ORDER BY `transport_ymd` ASC,`created_at`