SQL-Update

Question 1

How do you update rows in a database table?

Answer 1

To update rows you have to use the UPDATE statement followed by the name of the table you want to update in double quotes. Followed by the SET statement with the column name equal to the new value you want to change it to.

Question 2

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

Answer 2

If you do not include a WHERE clause you run the risk of updating all the values for one column accidentally