A data manipulation language (DML) is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data. DML is mostly incorporated in SQL databases.
UPDATE: This command modifies data of one or more records. An update command syntax is UPDATE table name SET column name = value where [condition].
INSERT: This command adds one or more records to a database table. The insert command syntax is INSERT INTO table name [column(s)] VALUES [value(s)].
DELETE: This command removes one or more records from a table according to specified conditions. Delete command syntax is DELETE FROM table name where [condition].
