Set automatic MySQL growth to start from a specified number

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,

'Class' varchar (2) not null,

'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;