1.查看最大的AUTO_INCREMENT
SELECT AUTO_INCREMENT from information_schema.tables where table_schema='contract' and table_name='contract';
2.修改最大的AUTO_INCREMENT
alter table tablename auto_increment=NUMBER;
1.查看最大的AUTO_INCREMENT
SELECT AUTO_INCREMENT from information_schema.tables where table_schema='contract' and table_name='contract';
2.修改最大的AUTO_INCREMENT
alter table tablename auto_increment=NUMBER;