Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

Difference between DML (Data Manipulation Language) and DDL (Data Definition Language)

Be First!
by January 9, 2017 Data Structure, DATABASE

Difference between DML (Data Manipulation Language) and DDL (Data Definition Language)

DML (Data Manipulation Language) and DDL (Data Definition Language)

Subsets of SQL commands:

DML (Data Manipulation Language) is the set of commands which modify the data itself. A few of these common commands are:

SELECT
UPDATE
INSERT
DELETE

DDL (Data Definition Language) is the set of commands which modify the schema, or structure of the database. This includes commands such as:
CREATE
DROP
ALTER
TRUNCATE

Check out the Wikipedia articles for DML and DDL for more information.

(0)

Previous
Next

Leave a Reply