MySQL database table self-increment primary key number irregular, rearranged

MySQL database table self-increment primary key ID is messed up and needs reordering.

Principle: Delete the original self-increment ID and re-establish the new self-increment ID.

1. Delete the original primary key:

ALTER TABLE DROP ' id ';

2. Add a new primary key field:

ALTER TABLE ADD 8  not NULL First;

3. Set the new primary key:

ALTER TABLE COLUMN 8  not NULL Auto_increment,ADDPRIMARYKEY

MySQL database table self-increment primary key number irregular, rearranged