关系数据库的语言 DQL/DML/DDL/DCL/TCL

关系数据库的语言

DQL: Data Query Language,

Some examples:

SELECT - retrieve data from the a database

DML: Data Manipulation Language,

Some examples:

INSERT - insert data into a table

UPDATE - updates existing data within a table

DELETE - deletes all records from a table, the space for the records remain

DDL: Data Definition Language,

Some examples:

CREATE - to create objects in the database

ALTER - alters the structure of the database

DROP - delete objects from the database

TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed

TCL: Transaction Control Language,

Some examples:

COMMIT - save work done

SAVEPOINT - identify a point in a transaction to which you can later roll back

ROLLBACK - restore database to original since the last COMMIT

DCL: Data Control Language.

Some examples:

GRANT - gives user's access privileges to database

REVOKE - withdraw access privileges given with the GRANT command