PostgreSQL - Tutorial 16 UPDATE AND DELETE IN TABLE

Published: 26 July 2020
on channel: txt2text

2,065

Update Method in PostgreSQL:

The PostgreSQL UPDATE Query is used to modify the existing records in a table. You can use WHERE clause with UPDATE query to update the selected rows. Otherwise, all the rows would be updated.

The basic syntax of UPDATE query with WHERE clause is as follows −

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];
----------------------------------------------------------------------------------------------------------------------
Delete Method:

The PostgreSQL DELETE Query is used to delete the existing records from a table. You can use WHERE clause with DELETE query to delete the selected rows. Otherwise, all the records would be deleted.

Syntax
The basic syntax of DELETE query with WHERE clause is as follows −

DELETE FROM table_name
WHERE [condition];
You can combine N number of conditions using AND or OR operators.

On this page of the site you can watch the video online PostgreSQL - Tutorial 16 UPDATE AND DELETE IN TABLE with a duration of hours minute second in good quality, which was uploaded by the user txt2text 26 July 2020, share the link with friends and acquaintances, this video has already been watched 2,065 times on youtube and it was liked by 9 viewers. Enjoy your viewing!