UPDATE basics

Update rows with UPDATE.

With UPDATE you change rows in a table. SET gives the new value; WHERE picks which rows.

UPDATE products
SET price = 10
WHERE id = 1;

This query sets the price of product 1 to 10.

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

UPDATE basics — details

Without WHERE, UPDATE changes every row; always give a condition. After SET you write column = value.

Set price to 10 for id=1 in products.

Show example solution

UPDATE products
SET price = 10
WHERE id = 1

New value

UPDATE products
____ price = 10
WHERE id = 1;

Show answer

UPDATE products
SET price = 10
WHERE id = 1;