Can you explain Insert, Update and Delete query

Insert statement is used to insert new rows in to table. Update to update existing data in the table. Delete statement to delete a record from the table. Below code snippet for Insert, Update and Delete :-

  • INSERT INTO pcdsEmployee SET name=’rohit’,age=’24’;
  • UPDATE pcdsEmployee SET age=’25’ where name=’rohit’;
  • DELETE FROM pcdsEmployee WHERE name = ‘sonia’;