Discussion in 'PHP' started by Digvijay Singh, Jan 17, 2013.
What are the difference between DDL and DML? And why and where should we use these term in SQL?
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.
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).
Separate names with a comma.