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

Order of values in INSERT

In the command INSERT INTO ... (columns) VALUES (values) - what is the relationship between the columns and the values?

Answer options

  • The values must be in the same order as the listed columns
  • The order of the values does not matter at all
  • The values are always sorted alphabetically
  • The values must be in the reverse order of the columns

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