DAY _ 4 : PostgreSQL Query Session.

 💬 Hey, Hello Friend's, Have A Nice Day.

 👊 Now, We Have to Move To Our Next Session.

 #UPDATE Operation Upon the Person Table.

 ✌ SYNTAX :

    UPDATE  Table_Name

   SET  Column_Name2 = New_Value

   WHERE  Condition;

QUERY_ : 

UPDATE Person

SET First_Name = 'John'

WHERE User_id = 'e595c249228789d';

• After Executing These SQL Query in PostgreSQL WorkBench.

SELECT First_Name, Last_Name 

FROM Person

WHERE User_id = 'e595c249228789d';

OUTPUT : 

First_Name | Last_Name

  John          |  Walker

#DELETE  Delete rows of a table.

 The PostgreSQL DELETE Statement allows you to delete one or more rows from a Table.

✌ SYNTAX :

    DELET FROM  Table_Name

   WHERE  Condition;

To Return the Delete row(s) to the client, You use the RETURNING Clause as Follows:

✌ SYNTAX :

    DELET FROM  Table_Name

   WHERE  Condition

    RETURNING ( Column_Name  | * );

 DELETE FROM Person

 WHERE User_ID  =  'e595c249228789d'

 RETURNING  *  ;

OUTPUT :