How to reset an automatic index in Mysql _ MySQL

Mysql auto-index reset method bitsCN.com

How to reset an automatic index in Mysql

Because some record rows are deleted, the auto-increment field is not consecutive for 1, 3, 4, 5, 7, 10.

In this way, to restore the sequential sorting of 1, 2, 3, 4, 5, 6, and 7, you only need to do the following:

Method 1: truncate table your table name

Method 2: delete from your table name dbcc checkident (your table name, reseed, 0)

// Locate the auto-increment field and start from 1.

BitsCN.com