1.

Can You Explain Insert, Update And Delete Query In Dbms?

Answer»

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 wbEmployee SET name='maxwell',age='22';
UPDATE wbEmployee SET age='22' where name='maxwell';
DELETE FROM wbEmployee WHERE name = 'david';

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 wbEmployee SET name='maxwell',age='22';
UPDATE wbEmployee SET age='22' where name='maxwell';
DELETE FROM wbEmployee WHERE name = 'david';


Discussion

No Comment Found

Related InterviewSolutions