Calculated updates

Update based on the current value.

Calculated update

You can use a calculation in SET. You can use the old column value in the new value.

UPDATE products
SET price = price * 1.10
WHERE category = 'kitap';

This query raises prices of all books by 10%.

In products, price = price * 1.10 is updated. Only the rows where category = 'kitap' holds are affected.

SET price = price * 1.10 takes the old price, multiplies by 1.10 and writes it back. Ideal for bulk price changes.

Raise all prices in products by 10%.

Show example solution

UPDATE products
SET price = price * 1.10

Raise price

UPDATE products
SET price = price ____ 1.10
WHERE category = 'kitap';

Show answer

UPDATE products
SET price = price * 1.10
WHERE category = 'kitap';