MySQL :: MySQL 8.4 Reference Manual :: 5.6.9 Using AUTO_INCREMENT

The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows: CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO animals (name) VALUES ('dog'),('cat'),('penguin'), ('lax'),('whale'),('ostrich'); SELECT * FROM animals; Which returns: +----+---------+ | id | name | +----+---------+ | 1 | dog | | 2 | cat | | 3 |

[aopico]

For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary column in a multiple-column index.

[takatoshiono]

To start with an AUTO_INCREMENT value other than 1,

[nitsuji]

To start with an AUTO_INCREMENT value other than 1,