select id+1 from TABLE where id+1 not in(select id from TABLE) and id+1<>(select max(id)+1 from TABLE) 执行后的结果就是缺少的 编号