Updating multiple columns in table
suggest changeYou can update multiple columns in a table in the same statement, separating col=val
pairs with commas:
UPDATE person
SET country = 'USA',
state = 'NY'
WHERE city = 'New York';
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents