Several methods of self-increment primary key zeroing in MySQL database

MySQL self-increment primary key zeroing method:

1. If none of the previous data is needed, you can simply empty all the data and count the self-increment field recovery starting at 1:

TRUNCATE TABLE table_name;

2. When the user does not have TRUNCATE permissions and the data is not needed:

1) Delete the original primary key:

ALTER TABLE ' table_name ' DROP ' ID ';

2) Add a new primary key:

ALTER TABLE ' table_name ' ADD ' ID ' int (one) not NULL first;

3) Set the new primary key:

ALTER TABLE ' table_name ' MODIFY COLUMN ' id ' int (one) not NULL Auto_increment,add PRIMARY KEY (ID);

3. When the user does not have permission:

You can directly set the Auto_increment value of the data table to the desired initial value, such as 10000:

ALTER TABLE ' table_name ' auto_increment= 10000;