#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2011
    Posts
    56
    Rep Power
    3

    UPDATE Multiple Values From One Column


    This is very basic for mostly everyone browsing this forum however I'm stuck and Google isn't giving me what I need and/or I can't seem to use the correct terminology to locate my answer. What I'm trying to do is update a single customer record from a table called 'customers'. They've moved and also changed their staff. I've been tasked to update the records :shocked: in the table to make sure we have their most up to date info. As it stands, their info is as follows:

    Code:
    forta=# SELECT cust_id, cust_name, cust_address, cust_contact, cust_email
    forza-# FROM customers
    forza-# WHERE cust_name LIKE 'Owl City'
    forza-# ;
      cust_id   | cust_name |     cust_address     | cust_contact |    cust_email
    ------------+-----------+----------------------+--------------+-------------------
     1000000010 | Owl City  | 7991 Maitland Avenue | Perry Gold   | perry@owlcity.org
    (1 row)
    Can someone please help me understand what the UPDATE command would look like if I needed to change the values for (cust_address, cust_contact, cust_email) rather than running the update command three times with different values?

    Code:
    UPDATE customers SET (cust_address, cust_contact, cust_email) VALUES ('1119 Orange Avenue', 'Jennifer Gold', 'jennifer@owlcity.org') WHERE cust_name = 'Owl City';
    ERROR:  syntax error at or near "VALUES"
    LINE 1: ...mers SET (cust_address, cust_contact, cust_email) VALUES ('1...
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Code:
    UPDATE customers 
       SET cust_address = '1119 Orange Avenue', 
           cust_contact = 'Jennifer Gold', 
           cust_email = 'jennifer@owlcity.org' 
    WHERE cust_name = 'Owl City';
    As documented in the manual:
    http://www.postgresql.org/docs/current/static/sql-update.html

IMN logo majestic logo threadwatch logo seochat tools logo