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

The danger of a missing WHERE

What happens when you run UPDATE without a WHERE clause?

Answer options

  • Nothing happens - the statement is ignored
  • Only the first row changes
  • The table is deleted
  • The change affects ALL rows in the table - a common and dangerous mistake

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