sql-update

Question 1

How do you update rows in a database table?

Answer 1

update “table name”
set “attribute column name” = ‘value’ and no single quotes if it’s a number value
where keyword to specific places to update

Question 2

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

Answer 2

it can update all the columns for all rows