sql update

Question 1

How do you update rows in a database table?

Answer 1

UPDATE “table”
SET “columnToUpdate” = ‘newValue’
WHERE “columnName” = ‘value’;

Question 2

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

Answer 2

Otherwise every row will update