Question · SQL and MySQL course · Module 5: Modifying data (DML)

Why we skip the id column

Why do we usually NOT provide the id column in an INSERT command?

Answer options

  • Because the id column does not exist in any table
  • Because id must always equal 0
  • Because INSERT does not allow numbers
  • Because id has the AUTO_INCREMENT property - the Library assigns the next number itself

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