Mysql auto_increment re-count

 

When clearing a table, re-insert the data and find that the field count of the auto_increment attribute is not from 1, you can use the following command

Method 1

 

Delete from test;

Alter table 'test' auto_increment = 1

(Benefit, you can set AUTO_INCREMENT to start with any value)

Tip: if there are many columns and data, the speed will be very slow. For example, if there are more than 0.9 million rows, it will take more than 10 minutes.

Method 2

Truncate table test

(Benefit, simple, AUTO_INCREMENT value re-starts counting)

 

From ay shadow