550502-kudravets
4/24/2019 - 12:14 PM
Поиск пропущенных последовательностей в БД
SELECT (`t1`.`phone`+1) as `empty_phone`
FROM `t1`
WHERE (
SELECT 1 FROM `t1` as `st` WHERE `st`.`phone` = (`t1`.`phone` + 1)
) IS NULL
ORDER BY `t1`.`phone`
LIMIT 1SELECT (`t1`.`phone`+1) as `empty_phone`
FROM `t1`
WHERE (
SELECT 1 FROM `t1` as `st` WHERE `st`.`phone` = (`t1`.`phone` + 1)
) IS NULL
ORDER BY `t1`.`phone`
LIMIT 1