[SQL] MySql 데이터 타입

http://dev.mysql.com/doc/refman/5.0/en/column-types.html

 

TINYINT             (-128 ~ 127)
SMALLINT          (-32768 ~ 32767)
MEDIUMINT        (-8388608 ~ 8388607)
INT                    (-2147483648 ~ 2147483647)
BIGINT               (-9223372036854775808 ~ 9223372036854775807)
FLOAT
DOUBLE
DECIMAL(NUMERIC)
DATE                 (1000-01-01 ~ 9999-12-31, YYYY-MM-DD)          
DATETIME         (1000-01-01 00:00:00 ~ 9999-12-31 23:59:59, YYYY-MM-DD HH:MM:SS)          
TIMESTAMP      (1970-01-01 00:00:00 ~ 2106..., YYYYMMDD[HH[MM[SS]]]) O        
TIME                 (-838:59:59 ~ 838:59:59, HH:MM:SS)          
YEAR                (1901 ~ 2155, 0000, YYYY)          
CHAR
VARCHAR
TINYTEXT          (0 ~ 255)          
TEXT                 (0 ~ 65535)          
MEDIUMTEXT     (0 ~ 16777215)          
LONGTEXT         (0 ~ 4294967295)          
TINYBLOB          (0 ~ 255)          
BLOB                 (0 ~ 65535)          
MEDIUMBLOB     (0 ~ 16777215)          
LONGBLOB         (0 ~ 4294967295)

[출처] [본문스크랩] MySql 데이터 타입|작성자 투윙오리