sql-update

Question 1

How do you update rows in a database table?

Answer 1

UPDATE “tableName”
SET “columnName” = ‘newDataInsert’
WHERE “row” = ‘valueYouAreQueryingFor’
RETURNING *;

Question 2

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

Answer 2

because without the WHERE clause it would update every row in the table