1 thought on “What is the difference between DDL, DML, DCL?”
Laurie
1. DML (Data Language) The them are Select, Update, INSERT, Delete, just like its name. These four commands are the language used to operate the data in the database. dml is data language. Some exmples: data operation language, processing data in SQL is collectively referred to as data manipulation language. 2, DDL (Data Language) DDL is more than DML. The main commands are Create, Alter, Drop, etc. DDL is mainly used in the structure of definition or changing tables, data types, tables, tables. Most of the links and constraints such as links and constraints are used when they are established. DDL is data language. Some exmples: Data define language, which is used to define and manage the language of all objects in the SQL database. 3, DCL (Data Control Language) The database control function. Sentences used to set or change database users or role permissions, including (GRANT, DENY, Revoke, etc.). In the default state, only persons such as Sysadmin, DBCREATOR, DB_OWNER, or DB_ have the right to execute DCL. DCL is data Control Language. Some Examples: Data control language, which is used to grant or recycle a certain privilege of access to the database, and control the time and effect of database manipulation of transactions, and monitor the database. The expansion information: 1, DDL description mode must be compiled by computer software to convert to formats that are convenient for computer storage, querying and manipulation. The program that completes this conversion work is called mode compiler. 2. It is usually a subset in the special programming language of the database. For example, in the SQL language of the information software industry, the three instructions of Insert, Update, and Delete are core, which represent the insertion, update and deletion, respectively. 3, data control language (Data Control Language) in the SQL language is a instruction that can control data access rights. Control of database objects such as function. Reference information Source: Baidu Encyclopedia-DDL (Data Definition Language) Baidu Encyclopedia-DML Baidu Encyclopedia-DCl
1. DML (Data Language)
The them are Select, Update, INSERT, Delete, just like its name. These four commands are the language used to operate the data in the database.
dml is data language. Some exmples: data operation language, processing data in SQL is collectively referred to as data manipulation language.
2, DDL (Data Language)
DDL is more than DML. The main commands are Create, Alter, Drop, etc. DDL is mainly used in the structure of definition or changing tables, data types, tables, tables. Most of the links and constraints such as links and constraints are used when they are established.
DDL is data language. Some exmples: Data define language, which is used to define and manage the language of all objects in the SQL database.
3, DCL (Data Control Language)
The database control function. Sentences used to set or change database users or role permissions, including (GRANT, DENY, Revoke, etc.). In the default state, only persons such as Sysadmin, DBCREATOR, DB_OWNER, or DB_ have the right to execute DCL.
DCL is data Control Language. Some Examples: Data control language, which is used to grant or recycle a certain privilege of access to the database, and control the time and effect of database manipulation of transactions, and monitor the database.
The expansion information:
1, DDL description mode must be compiled by computer software to convert to formats that are convenient for computer storage, querying and manipulation. The program that completes this conversion work is called mode compiler.
2. It is usually a subset in the special programming language of the database. For example, in the SQL language of the information software industry, the three instructions of Insert, Update, and Delete are core, which represent the insertion, update and deletion, respectively.
3, data control language (Data Control Language) in the SQL language is a instruction that can control data access rights. Control of database objects such as function.
Reference information Source:
Baidu Encyclopedia-DDL (Data Definition Language)
Baidu Encyclopedia-DML
Baidu Encyclopedia-DCl