mysql数据库表自增ID批量修改 AUTO_INCREMENT
SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' AUTO_INCREMENT = 1;' ) FROM information_schema.tables WHERE table_schema = 'test' LIMIT 0 , 10000;
mysql数据库表自增ID批量修改 AUTO_INCREMENT
SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' AUTO_INCREMENT = 1;' ) FROM information_schema.tables WHERE table_schema = 'test' LIMIT 0 , 10000;