Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

update multiple columns in postgres

postgres=# update sales 
           set order_date='2020-12-04', 
               amount=250 where id=3;

postgres=# select * from sales;
id | order_date | amount
----+------------+--------
1 | 2020-12-01 | 100
2 | 2020-12-02 | 250
3 | 2020-12-04 | 250
UPDATE 1
Source by ubiq.co #
 
PREVIOUS NEXT
Tagged: #update #multiple #columns #postgres
ADD COMMENT
Topic
Name
1+4 =