What are the difference between DDL and DML?

[Die Hard]

What are the difference between DDL and DML? And why and where should we use these term in SQL?

[Luca tall]

DDL statemants are used to define the data structure or schema for example TRUNCATE,ALTER,DROP and CREATE.
DML statements are used for managing the data withion schema objects for example SELECT,INSERT,UPDATE,DELETE,MERGE,CALL,EXPLAIN PLAN and LOCK TABLE.

[keith.bowman]

DDL stands for data definition language which is often used to define the database structure or schema. On the other hand, DML stands for Data Manipulation Language which is often used for managing data within schema objects.

[AlfredBellemare]

DDL: Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:

    CREATE - to create objects in the database
    ALTER - alters the structure of the database
    DROP - delete objects from the database
    TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
    COMMENT - add comments to the data dictionary
    RENAME - rename an object

DML: Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

    SELECT - retrieve data from the a database
    INSERT - insert data into a table
    UPDATE - updates existing data within a table
    DELETE - deletes all records from a table, the space for the records remain
    MERGE - UPSERT operation (insert or update)
    CALL - call a PL/SQL or Java subprogram
    EXPLAIN PLAN - explain access path to data
    LOCK TABLE - control concurrency

[Ghazala]

Hello Friends,

Data Manipulation Language (also known as DML) is a family of computer languages. They are used by computer programs, and/or database users, to manipulate data in a database – that is, insert, delete and update this data in the database.

Data Definition Language (also known as DDL) is a computer language used to define data structures – as its namesake suggests. It first made its appearance in the CODASYL database model (a model pertaining to the information technology industry consortium, known as Conference on Data Systems Languages).

Thanks

[TomClarke]

DDL and DML are two types of Database Languages. They are called sub-languages, as they have fewer facilities than full-fledged programming languages.
DDL stands for Data Definition Language, and mainly used to define the schema  within a database. It also defimes the relationship between the entries within the database. DML stands for Data Manipulation Language and also a Database Language. And unlike DDL, DML can be utilized to insert, delete, revive and modify the data, rather than just specify it.