-
AUTO_INCREMENT
The initial
AUTO_INCREMENT
value for the table. In MySQL 5.6, this works forMyISAM
,MEMORY
,InnoDB
, andARCHIVE
tables. To set the first auto-increment value for engines that do not support theAUTO_INCREMENT
table option, insert a “dummy” row with a value one less than the desired value after creating the table, and then delete the dummy row.For engines that support the
AUTO_INCREMENT
table option inCREATE TABLE
statements, you can also useALTER TABLE
to reset thetbl_name
AUTO_INCREMENT =N
AUTO_INCREMENT
value. The value cannot be set lower than the maximum value currently in the column.
MySQL基础知识---------AUTO_INCREMENT
最新推荐文章于 2021-01-15 06:26:35 发布