SQLzoo.net

CREATE a table with an autonumber / sequence / identity / autoincrement

MySQL
An auto number field can provide a unique identifier where no other is available.
Run the tidy code silently


Specific to MySQL
You may specify AUTO_INCREMENT on a secondary column in a multiple column index. CREATE TABLE Examples of auto increment

Related links:

  • CREATE, DROP and ALTER