Database Reference
In-Depth Information
Updating multiple columns
As in the SQL
UPDATE
statement, we can specify multiple column-value pairs to be up-
dated in a single statement. Let's say
dave
wants to change his email address and also
enter a location:
UPDATE "users"
SET "email" = 'dave@me.com', "location" = 'San Francisco, CA'
WHERE "username" = 'dave';
On checking the table again, we see that both columns have been updated in the
dave
row:
