Set the automatic MySQL Growth Method to start from a specified number

Set the automatic MySQL Growth Method to start from a specified number

The auto-increment field must be set to primary key.

The following example uses the specified value starting from 1000.

1. Set it when creating a table:

CREATE TABLE `Test` (      `ID` int(11) NOT NULL AUTO_INCREMENT,      `NAME` varchar(50) NOT NULL,       `SEX` varchar(2) NOT NULL,      PRIMARY KEY (`ID`)           ) ENGINE=MEMORY AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC 

2. If you do not set a table during table creation and want to set it later, you can modify the settings:

Alter table Test auto_increment = 1000;

Example 2:

create table user(  id integer primary key,  firstname varchar(200) not null,  lastname varchar(200) not null);   alter table user modify id integer auto_increment ;  alter table user modify id integer default '1'; 

Sometimes it is necessary to reset (Restore/restore) the fields set as auto_increment in mysql. Therefore, there are three ways to do this:

1. Reset the value of autoIncrement directly.

Alter table table_name AUTO_INCREMENT = 1;

2. truncate table

Truncate table table_name;

3. Delete the table and recreate the table.

Drop table table_name;
Create table table_name {...};

The above method for setting MySQL automatic growth starts from a specified number. It is all the content that I have shared with you. I hope to give you a reference and support for the customer's house.