DML DDL DCL in the database Tcl

Tag: Control data SQL Update date class blog role ack

DDL (data definition Language): Database definition language

Used to define the SQL commands used to create the action table, such as Create, ALTER, drop, and so on.

DML (Data Manipulation language): Manipulation language

Operations on specific data in a table, such as SELECT, UPDATE, INSERT, delete.

DCL (Data Control Language): Database Control Language

The control settings used for the database, such as the database role, the login permission grant.

TCL (Transaction Control Language): Database transaction Control Language

For SQL statement thing control, such as set TRANSACTION COMMIT ROLLBACK

DML DDL DCL in the database Tcl