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.