sql-update-Q&A

Question 1

How do you update rows in a database table?

Answer 1

update “table”
set “column” = number
where “row” = number;

Question 2

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

Answer 2

It changes the entire column you selected if not specified