Practise · Change only what you meant

Opening your saved work…

The reading

Change only what you meant

UPDATE menu_items
SET price = ROUND(price * 1.05, 2)
WHERE category = 'Tea';

Seven rows change. Run the preview's SELECT again to see the new prices. Open in the playground

UPDATE menu_items SET price = ROUND(price * 1.05, 2) WHERE category = 'Tea' raises seven prices. SET takes one or more column = value pairs, and the value can be an expression that uses the row's current values. WHERE picks the rows. Leave the WHERE off and the statement is still valid SQL, it still reports success, and it changes every row in the table. There is no confirmation step. The WHERE is the statement.

Read changes() immediately after. It is the number of rows the last statement touched, seven for the tea raise, 45 for the version without a WHERE. A zero means the WHERE matched nothing, which is a result to notice, not to accept.

An UPDATE has to satisfy every constraint an insert does. Set a price to NULL and the engine refuses: NOT NULL constraint failed, and the row is untouched.

Rule of thumb. An UPDATE without a WHERE changes every row and says nothing. Write the WHERE first.

Change only what you meant · UPDATE ... SET ... WHERE, and changes() · level 3 of 6

How many rows will the raise change?

Level 3: Predict the result · Exercise 1 of 1

UPDATE employees SET hourly_wage = hourly_wage + 1 WHERE position = 'Barista'. Before you check, how many rows does it change?

SELECT COUNT(*) AS rows_touched
FROM employees
WHERE position = 'Barista';

The query. Predict before you run it.

Data: Northshore Coffee.

I would like help with this exercise

Opens once your prediction is right, or after the worked answer.

Query results

The real result appears here after you run it.

Practice here is evidence for you and your instructor, never a grade. Grades live in Canvas.