[日本語]

This is a memo of SQL commands which I learned from workplace and self-study.

If you do not know SQL, please refer to “Database, DBMS and SQL“. Here, SQL commands are classified as follows.

・DDL

・DML

・DCL

・Others

• DCL (Data Control Language)

Commands for transaction and access to the database.

Prof. Wiki：”A syntax similar to a computer programming language used to control access to data stored in a database (Authorization).”

• List and Description of DCL Commands

– Authorize specific database users to perform specific tasks

GRANT

– Remove authority already given from a specific database user

REVOKE

– Start a new transaction

BEGIN

– Commit the current transaction and make its changes permanent

COMMIT

– Roll back the current transaction and undo its changes

ROLLBACK

20190701