設定MySQL自動成長從某個指定的數開始

以指定從1000開始為例。

1 建立表的時候就設定： 

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 如果在建立表時沒有設定，後來想設定，可以通過修改實現：

 

alter   table   Test   auto_increment   =   1000;