Question · SQL and MySQL course · Module 4: Creating tables (DDL)

How UNIQUE works

What does the UNIQUE constraint placed on the email column guarantee?

Answer options

  • The email is always filled in automatically
  • No two rows may have the same email value
  • The email may be empty, but not numeric
  • The email becomes the primary key

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