Find the UPDATE Mistake
Find the Mistake Easy
Question
This UPDATE is dangerous. Find the mistake:
Code
UPDATE users SET name = 'Ada';
Hint
What happens without a WHERE clause?
Explanation
This UPDATE has no WHERE clause, so it updates ALL rows in the users table — every user's name becomes 'Ada'. The fix is to add WHERE id = 1 (or the appropriate condition) to target only the intended row.
Related Resources
Related Lessons
- Insert, Update, Delete
Learn UPDATE safety.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.