MySQL基础知识---------AUTO_INCREMENT

最新推荐文章于 2021-02-02 09:24:23 发布

原创最新推荐文章于 2021-02-02 09:24:23 发布 · 820 阅读

CC 4.0 BY-SA版权

19 篇文章

订阅专栏

本文详细介绍了MySQL中AUTO_INCREMENT选项的用法，包括如何设置初始AUTO_INCREMENT值，以及如何通过ALTER TABLE语句重置AUTO_INCREMENT值。重点强调了不支持AUTO_INCREMENT表选项的引擎的特殊处理方式。

AUTO_INCREMENT

The initial AUTO_INCREMENT value for the table. In MySQL 5.6, this works for MyISAM, MEMORY, InnoDB, andARCHIVE tables. To set the first auto-increment value for engines that do not support the AUTO_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 in CREATE TABLE statements, you can also useALTER TABLE tbl_name AUTO_INCREMENT = N to reset the AUTO_INCREMENT value. The value cannot be set lower than the maximum value currently in the column.