top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is DML (Data Manipulation Language) ?

+2 votes
124 views
What is DML (Data Manipulation Language) ?
posted Jan 30, 2014 by Mona Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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].

answer Feb 1, 2014 by Prachi Agarwal
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...