SQL - UPDATE

Overview

Always include a WHERE when updating unless you intend to change all rows.

UPDATE employees
SET salary = salary * 1.05
WHERE department_id = 1;

UPDATE employees
SET salary = salary * 1.05
WHERE department_id = 1;

UPDATE employees
SET salary = salary * 1.05
WHERE department_id = 1;

Prerequisite

Load the Standard Test Data.

Expected Output (live; wrapped in a transaction)

Sample Use Cases (4)

1) Give 10% raise to all Engineers (dept_id=1)

2) Set city='Remote' where city IS NULL

3) Standardize title casing

4) Set hired_at to current time if NULL