Question · SQL and MySQL course · Module 4: Creating tables (DDL)
The role of AUTO_INCREMENT
What is AUTO_INCREMENT used for on the id column?
Answer options
- MySQL itself assigns the next, automatically increasing number to each new row
- It increases the table size on disk
- It sorts rows in descending order
- It removes duplicates from the table
You can check the correct answer by solving this task in the CodeWorlds game.