MySQL 如何快速查出缺失数据的主键 id
例如,有如下数据:
id 1,3,7,8,10
如何快速查出缺失的:
2,4,5,9
SELECT a.id+1 AS START, MIN(b.id) - 1 AS END
FROM limit_up_predict AS a, limit_up_predict AS b
WHERE a.id < b.id
GROUP BY a.id
HAVING START < MIN(b.id)
MySQL 如何快速查出缺失数据的主键 id
例如,有如下数据:
id 1,3,7,8,10
如何快速查出缺失的:
2,4,5,9
SELECT a.id+1 AS START, MIN(b.id) - 1 AS END
FROM limit_up_predict AS a, limit_up_predict AS b
WHERE a.id < b.id
GROUP BY a.id
HAVING START < MIN(b.id)