TOOL/DATABASE 2015. 5. 4. 14:32

-------------------------------------------

---------------

---------------------------------------------



------------------------- DB(DataBase) 자료형

TINYINT

SMALLINT

MEDIUMINT

INT

BIGINT

FLOAT

DOUBLE

REAL

DATE

DATETIME

TIMESTAMP

TIME

YEAR

CHAR

VARCHAR

TINYTEXT

TEXT

MEDIUMTEXT

LONGTEXT

MEDIUMBLOB

LONGBLOB

BLOB

BINARY

VARBINARY

ENUM

SET

BOOL




------------------------- SQL (Structured Query Language)

----- DDL (Data Definition Language)

Create Table

Alter Table

Drop Table


----- DML (Data Manipulation Language) 

Select

Insert

Delete

Update

'TOOL > DATABASE' 카테고리의 다른 글

DECODE()  (0) 2015.11.25
RANK(), ROWNUMBER()  (0) 2015.11.13
DB 심화  (0) 2015.09.15
ORACLE쿼리를 MYSQL쿼리로 바꿔야할 상황이 생겼다.  (1) 2015.06.18
Oracle  (0) 2015.05.04