2019-06-19 21:34:45
DDL (Data Definition Language)
CREATE
DROP
ALTER
TRUNCATE
COMMENT
RENAME
DML (Data Manipulation Language)
SELECT
INSERT
UPDATE
DELETE
DCL (Data Control Language)
GRANT
- Gives users access privileges to database objects.REVOKE
- Withdraw users access privileges given by using the GRANT command.
TCL (Transaction Control Language)
COMMIT
- commits a transaction.ROLLBACK
- Rollbacks a transaction in case of error occurs.SAVEPOINT
- Sets a savepoint within a transaction.SET TRANSACTION
- Specify characteristics for the transaction.