sql-update

Question 1

How do you update rows in a database table?

Answer 1

update “products”

set “price” = 100;

Question 2

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

Answer 2

HOWEVER there is a serious problem with this query as it would update every row in the table!