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.