Conditional UPDATE

Make UPDATE conditional with WHERE.

Multi-column update

With SET you can update several columns separated by commas.

UPDATE products
SET price = 10, stock = 50
WHERE id = 1;

This query sets price to 10 and stock to 50.

In products, price = 10, stock = 50 is updated. Only the rows where id = 1 holds are affected.

Each column = value pair is separated by a comma. Order does not matter; multiple columns change at once.

Set price=10 and stock=50 for id=1 in products.

Show example solution

UPDATE products
SET price = 10, stock = 50
WHERE id = 1

Two columns

UPDATE products
SET price = 10____ stock = 50
WHERE id = 1;

Show answer

UPDATE products
SET price = 10, stock = 50
WHERE id = 1;