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