sql-update

Question 1

How do you update rows in a database table?

Answer 1

Update “table name”
Set “column name” = ‘value’ (no quotes if a number)
Where “column name” followed by condition

Question 2

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

Answer 2

If you do not include where, it will update every row in the table with the value