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

Inserting NULL

How do you mark in an INSERT command that a given column has no value?

Answer options

  • Write 'NULL' in single quotes like text
  • Write the number 0
  • Leave empty single quotes '' - that always gives NULL
  • Write the word NULL in place of the value (without single quotes)

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