select id from (select id from enterprise where id <![CDATA[>]]>#{start} order by id asc) t where not exists (select 1 from enterprise where id=t.id-1) limit 1
否则自增会越来越大,又不能使用OPMIZE TABLE 来优化表空间
select id from (select id from enterprise where id <![CDATA[>]]>#{start} order by id asc) t where not exists (select 1 from enterprise where id=t.id-1) limit 1
否则自增会越来越大,又不能使用OPMIZE TABLE 来优化表空间
© 著作权归作者所有