How to set auto-increment ID in mysql

Mysql method to set auto-increment ID: execute the [CREATE TABLE empautoinc(ID INT PRIMARY KEY AUTO_INCREMENT) AUTO_INCREMENT = 0;] statement.

The auto-increment column of MYSQL must be an indexed column, and the seed value must be set at the end of the table.

(Recommended tutorial:mysql video tutorial)

--mysql-- 设置自增ID从N开始 CREATE TABLE empautoinc( ID INT PRIMARY KEY AUTO_INCREMENT ) AUTO_INCREMENT = 100 ; --（设置自增ID从100开始）

insert into empautoinc(id) values(null); Query OK, 1 row affected (0.00 sec) mysql> select * from empautoinc; +-----+ | ID | +-----+ | 100 | +-----+ 1 row in set (0.00 sec)

Related recommendations:mysql tutorial

The above is the detailed content of How to set auto-increment ID in mysql. For more information, please follow other related articles on the PHP Chinese website!