MySQL self-increment ID start value modified

Many friends in MySQL think that the field auto_increment type self-increment ID value can not be modified, in fact, this understanding is wrong, the following describes the MySQL self-increment ID starting value modification and setting method.
The usual way to set the self-increment field:
Add when creating a table:

key,...)

After creating the table, add:

Key key.

Many times you want the ID of the data in the table not starting from 1, like QQ, ID starting from 10000
The code is as follows:

ALTER TABLE users auto_increment=10000;

And the statement also applies to modify the ID of an existing table, such as large batches of deleted data, the ID from 654321 to 123456 start

ALTER TABLE users auto_increment=123456;

MySQL self-increment ID start value modified