Mysql Data Type

sql 2009. 1. 7. 11:32
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)

'sql' 카테고리의 다른 글

mysql tunning  (2) 2009.01.07
mysql  (0) 2009.01.07
mysql query  (0) 2009.01.07
mysql password 잊어버렸을때  (0) 2009.01.07
mysql 백업  (0) 2009.01.07
Posted by 으랏차
,