Table of contentsClick link to navigate to the desired location
This content has been automatically translated from Ukrainian.
TCL (Transaction Ccontrol Llanguage), DCL (Data Ccontrol Llanguage) and DQL (Data Query Llanguage) are important elements in databases. We've previously covered DDL and DML. For a complete understanding, also consider TCL, DCL and DQL.
TCL (Transaction Control Language)
TCL used to manage transactions in the database. It allows you to perform commit (confirmation), rollback (cancellation) and save the recovery point in the database.
- COMMIT: Confirmation of the transaction.
- ROLLBACK: Cancellation (rollback) of a transaction.
- SAVEPOINT: Saving the recovery point within a transaction.
DCL (Data Control Language)
DCL used to manage data access rights in a database. Includes granting or revoking access rights to users and roles, as well as privilege management.
- GRANT: Granting access rights to users or roles.
- REVOKE: Abolition of access rights to users or roles.
DQL (Data Query Language)
DQL is a data query language used to sample (search) data from a database. It allows you to perform various requests to obtain the necessary information from the database.
- SELECT: Sampling (searching) data from the database using various conditions and criteria.
Difference between TCL, DCL and DQL
TCL is used to manage transactions, DCL - to manage access rights, and DQL - for sampling data from the database. Each of these languages plays an important role in the management and use of databases.
This post doesn't have any additions from the author yet.
