Essential Books

Updating multiple columns in table

suggest change

You 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.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

UPDATE:
* Updating a table based on joining another table
* Update all rows in a table
* Update all rows meeting a condition
* Updating multiple columns in table
Table Of Contents