1. I've started a massive SPAM purge, any accounts that have spammed are being removed, also for a short period new user signups are disallowed until the SPAM cleaning is finished.

What are the difference between DDL and DML?

Discussion in 'PHP' started by Digvijay Singh, Jan 17, 2013.

  1. Digvijay Singh

    Digvijay Singh New Member

    Joined:
    Oct 30, 2012
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Gender:
    Male
    Location:
    Delhi, India
    What are the difference between DDL and DML? And why and where should we use these term in SQL?
    Loading...
  2. lindanancy1

    lindanancy1 New Member

    Joined:
    Jan 22, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Gender:
    Male
    Location:
    United States
    Data Definition Language (DDL) statements are used to define the database structure or schema, like Create, Alert, Drop, Truncate,etc.
    Data Manipulation Language (DML) statements are used for managing data within schema like Select, Insert, Update, Delete,etc..Because SQL More powerful & security database compare to other databse.
  3. anirban09P

    anirban09P Member

    Joined:
    Jun 30, 2014
    Messages:
    196
    Likes Received:
    0
    Trophy Points:
    16
    Gender:
    Female
    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). DDL was used within the schema of the database in order to describe the records, fields, and ‘sets’ that made up the user Data Model. It was at first a way in which programmers defined SQL. Now, however, it is used generically to refer to any formal language used to describe data or information structures (for example, XML schemas).

Share This Page