Question · SQL and MySQL course · Module 11: Capstone project

The role of AUTO_INCREMENT

What does AUTO_INCREMENT on an id column do?

Answer options

  • It increases the book's price by one
  • It sorts the rows in descending order
  • It automatically assigns the next unique number to each new row
  • It removes duplicates from the table

You can check the correct answer by solving this task in the CodeWorlds game.