Methods for resetting the auto-increment start value of various MySQL Data Table types

After the MyISAM data table deletes the maximum number of records, the number cannot be reused. You can use the "AUTO_INCREMENT = n" option to specify an auto-increment initial value when creating a table. After the table is created, use the alter table table_name AUTO_INCREMENT = n command to reset the start value of the auto-increment. The auto-incrementing column is allowed only when the HEAP table of www.2cto.com HEAP data table is MySQL4.1. You can use the "AUTO_INCREMENT = n" option to specify an auto-increment initial value when creating a table. After the table is created, use the alter table table_name AUTO_INCREMENT = n command to reset the start value of the auto-increment. The "AUTO_INCREMENT = n" option cannot be used to specify the auto-increment initial value in the create table data table www.2cto.com BDB. You cannot use the alter TABLE table_name AUTO_INCREMENT = n command to change the auto-increment initial value. InnDB data tables cannot use the "AUTO_INCREMENT = n" option in create table to specify the auto-increment initial value, or use the alter table table_name AUTO_INCREMENT = n command to change the auto-increment initial value.