DML – Data Manipulation Language
DML statements are used for inserting, deleting and updating data in a database. The queries include SELECT, UPDATE, INSERT and DELETE.
Some other data manipulation language operations include MERGE, CALL, EXPLAIN PLAN and LOCK TABLE. Data Manipulation Language (DML) describes the portion of SQL that allows you to manipulate or control your data.
A sample data deletion statement for deleting the record of employee will be :-
DELETE FROM employee
WHERE employeeid = 12
Leave a Reply