sql-update

Question 1

How do you update rows in a database table?

Answer 1

update statement
update “products”
set “price” = 100
where “productId” = 24;

Question 2

Why is it important to include a where clause in your update statements?

Answer 2

To target specific rows.