DML: data operation language. operations such as data processing in SQL are collectively referred to as data operation languages. They are SELECT, UPDATE, INSERT, and DELETE, just like their names, these four commands are used to operate on the data in the database. without modifying the table structure, only the table content needs to be modified by commit to be truly executed by DDL: Data Definition Language,
DML: data operation language. operations such as data processing in SQL are collectively referred to as data operation languages. They are SELECT, UPDATE, INSERT, and DELETE, just like their names, these four commands are used to operate on the data in the database. without modifying the table structure, only the table content needs to be modified by commit to be truly executed by DDL: Data Definition Language,
DML: data operation language. operations such as processing data in SQL are collectively referred to as data operation languages.
They are SELECT, UPDATE, INSERT, and DELETE, just like their names. These four commands are used to operate on the data in the database,Only the table content is modified without modifying the table structure.
A commit is required to be executed.
DDL: a data definition language used to define and manage all objects in an SQL database.
DDL is more than DML. The main Commands include CREATE, ALTER, and DROP. DDL is mainly used inDefine or change the TABLE structure, data type, and initialization of links and constraints between tables.Most of them are used when creating tables.
DCL: a data control language used to grant or revoke a certain privilege to access the database, control the time and Effect of database operations, and monitor the database.
Is the database control function. Is a statement used to set or change database user or role permissions, including (grant, deny, revoke, etc.) statements. By default, only sysadmin, dbcreator, db_owner, db_securityadmin, and other personnel are authorized to execute DCL.