UPDATE All Versions

Examples

• 0

  Update all rows in a table

  edit move example delete share

  0

  You update all rows in table by simply providing a column_name = value:

  UPDATE person SET planet = 'Earth'
  

  created Jul 23 at 19:21

  
• 0

  Update all rows meeting a condition

  edit move example delete share

  0

  UPDATE person SET state = 'NY' WHERE city = 'New York'
  

  created Jul 23 at 19:21

  
• 0

  Updating a table based on joining another table

  edit move example delete share

  0

  You can also update data in a table based on data from another table:

  UPDATE person 
  SET state_code = cities.state_code 
  FROM cities
  WHERE cities.city = city
  

  Here we are joining the person city column to the cities city column in order to get the city's state code. This is then used to update the state_code column in the person table.

  created Jul 23 at 19:21

  
• 0

  Updating multiple columns in table

  edit move example delete share

  0

  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'
  

  created Jul 23 at 19:21