通过选择结果更改AUTO_INCREMENT值

试试这个：

SELECt `AUTO_INCREMENT` INTO @AutoIncFROM INFORMATION_SCHEMA.TABLESWHERe TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'another_table_name';SET @s:=CONCAt('ALTER TABLE `database_name`.`table_name` AUTO_INCREMENT=', @AutoInc);PREPARE stmt FROM @s;EXECUTE stmt;DEALLOCATE PREPARE stmt;