Summary - UPDATE

Combine WHERE and calculated values for safe updates.

In this group you learned UPDATE basics, multi-column, conditions, calculations and subqueries. Updating data is now easy.

UPDATE products
SET price = price * 1.10, stock = stock + 5
WHERE category = 'kitap';

This query raises book prices by 10% and adds 5 to stock.

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

Exercise Summary - UPDATE

Set price to 10 for id=1 in products.

Show example solution

UPDATE products
SET price = 10
WHERE id = 1