PostgreSQL - Tutorial 16 UPDATE AND DELETE IN TABLE
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.
Sur cette page du site, vous pouvez voir la vidéo en ligne PostgreSQL - Tutorial 16 UPDATE AND DELETE IN TABLE durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur txt2text 26 juillet 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 2,065 fois et il a aimé 9 téléspectateurs. Bon visionnage!
