CodesJava

Easy learning with example program codes

UPDATE Query in PostgreSQL

PostgreSQL UPDATE
To update the existing records in a table one can use the UI or can use the PostgreSQL UPDATE statement.

Syntax:

UPDATE table_name
SET column_1 = expr_1,  
    column_2 = expr_2,  
    ...  
    column_n = expr_n  
WHERE conditions;  

UPDATE statement using UI:
Other than Query tool, we can also UPDATE statement in PostgreSQL using UI. To UPDATE statement using UI in PostgreSQL, follow the below steps.

  • Right-click on the selected table.
  • Move your cursor over the option scripts.
  • Click on the “UPDATE script” option.
  • Put the values on the place of “?”.
  • Fulfill the WHERE condition.
  • Click on the “play” button.

Example 1: Updating a single column of a table.
Employment table before update:

ID	STATE	RATE
1	A	60
2	B	70
3	C	65
4	D	80
5	E	78
UPDATE “EMPLOYMENT”    
SET “RATE” = 85 
WHERE “ID” = 3;

Explanation:
The RATE will be updated to 85 where ID is 3.

Employment table after update will be like this:

ID	STATE	RATE
1	A	60
2	B	70
3	C	85
4	D	80
5	E	78

Example 2: Updating multiple columns of a table.
Employment table before update:

ID	STATE	RATE
1	A	60
2	B	70
3	C	65
4	D	80
5	E	78
UPDATE “EMPLOYMENT”    
SET “RATE” = 85, “STATE” = ‘F’
WHERE “ID” = 3;

Explanation:
The RATE will be updated to 85 and STATE will be updated to ‘F’ where ID is 3.

Employment table after update will be like this:

ID	STATE	RATE
1	A	60
2	B	70
3	F	85
4	D	80
5	E	78

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status