Set MySQL autogrow to start from a specified number

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

To specify starting from 1000, for example.
1 Set the table when you create it:

CREATE TABLE ' Test ' (          ' ID ' int (one) ' is not null auto_increment,          ' NAME ' varchar (2) is not NULL,             ' SEX ' varchar 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 the table when you create it, and then you want to set it, you can modify the implementation:

Alter   table   Test   auto_increment   =   

CREATE TABLE User (  ID integer primary key,  FirstName varchar ($) NOT NULL,  LastName varchar ($) NOT NULL );  ALTER TABLE user modify ID integer auto_increment;  

REF:

http://stevenjohn.iteye.com/blog/976397

Http://www.cnblogs.com/macro-cheng/archive/2011/11/08/mysql-003.html

Set MySQL autogrow to start from a specified number