- DDL(Data Definition Language)
CREATE (생성)
ALTER (수정)
DROP (삭제)
RENAME
TRUNCATE (데이터 초기화, 데이터만 지움)
- DML(Data Manipulation Language)
SELECT
INSERT
UPDATE
DELETE
- DCL(Data Control Language)
GRANT (권한을 줌)
REVOKE (권한을 뺌)
* TCL(Transaction Control Language)
COMMIT
ROLLBACK
SAVEPOINT
'programing > DB' 카테고리의 다른 글
Collation 오류 (JDBC + MariaDB) (0) | 2018.11.07 |
---|---|
DAO (Data Access Objects) (0) | 2018.02.09 |
정규화(Nomalization) (0) | 2017.07.28 |