SELECT
id
FROM
( SELECT id FROM sys_definition_menu ORDER BY id ASC ) t
WHERE
NOT EXISTS ( SELECT 1 FROM sys_definition_menu WHERE id = t.id - 1 )
查询数据库不连续id
最新推荐文章于 2024-07-05 03:13:08 发布
SELECT
id
FROM
( SELECT id FROM sys_definition_menu ORDER BY id ASC ) t
WHERE
NOT EXISTS ( SELECT 1 FROM sys_definition_menu WHERE id = t.id - 1 )