对于InnoDB，truncate会重置auto_increment的值为1。 delete后表仍然保持auto_increment。 但是在做delete整个表之后重启MySQL的话，则重启后的auto_increment会被置为1。

I'm trying to remove the DEFAULT value from some mediumint and int columns in a MyISAM table.ALTER TABLE `table_name` ALTER COLUMN `column_name` DROP DEFAULT;MySQL says that this query is executed ...

Recursively delete items in a MySQL table - foreign key, or something else? OldManBrodie Sep 25, 2013 Jump to latest Follow Reply ...