IT/Database

[Database] DDL / DML / DCL

순수나꾸 2009. 11. 21. 11:37

DDL(Data Definition Language)

  - CREATE, ALTER, DROP, TRUNCATE, GRANT, REVOKE, COMMENT

 

DML(Data Manipulation Language)

  - INSERT, UPDATE, DELETE, SELECT, LOCK TABLE, EXPLAIN PLAN, CALL

 

DCL(Data Control Language)

  - SET TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT