Answer
UPDATE changes column values in existing rows. • SET defines the new values. • WHERE chooses which rows are updated. • Without WHERE, every row in the target table is eligible.
💡 SQL Example
UPDATE employees
SET salary = salary * 1.05
WHERE department_id = 10;
Result
UPDATE 4
⚡ Quick Revision
UPDATE changes selected existing rows.