develog

[DB] DDL, DML, DCL 본문

DB/DB common

[DB] DDL, DML, DCL

냐옴 2017. 3. 27. 10:25

DDL (Data Definition Language)

CREATE
DROP
ALTER
TRUNCATE
COMMENT
RENAME 

DML (Data Manifulation Language)

SELECT
INSERT
UPDATE
DELETE
MERGE
CALL
EXPLAIN PLAN
LOCK TABLE

DCL (Data Control Language)

GRANT
REVOKE

TCL (Transaction Control Language)

COMMIT
ROLLBACK
SAVEPOINT
SET TRANSACTION


'DB > DB common' 카테고리의 다른 글

[DB] DB version  (0) 2017.04.25
[jdbc] jdbc, driver, connection url  (0) 2016.06.02
ROWNUM, TOP, LIMIT  (0) 2015.10.22
Configuring Connection Pooling in Tomcat  (0) 2013.03.07
rownum, top, limit  (0) 2013.03.06
Comments