Mysql Auto_increment re-count (let ID start from 1)

When emptying a table, reinsert the data and find that the field count of the Auto_increment attribute is not starting at 1, you can use the following command method

Delete from test;
ALTER TABLE ' Test ' auto_increment=1
(Benefit, you can set auto_increment to start at any value)
Tip: If the table columns and data are many, the speed will be very slow, such as 90多万条, will be more than 10 minutes.

Method Two

TRUNCATE TABLE test
(benefit, simple, auto_increment value restart count)

In general we use the second one, and remember that all of the records are completely deleted.

Mysql Auto_increment re-count (let ID start from 1)