重置mysql主键自增值
SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name=”xxx”;
ALTER TABLE xxx auto_increment=103 ;
修改后
SELECT AUTO_INCREMENT FROM information_schema.tables WHERE table_name=”xxx”;
ALTER TABLE xxx auto_increment=103 ;
修改后