sql-update

Question 1

How do you update rows in a database-table?

Answer 1

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

Question 2

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

Answer 2

So that it only targets specific rows