Type | Bytes | Minimum Value | Maximum Value | |
TINYINT | (Signed) | 1 | -128 | 127 |
(Unsigned) | 0 | 255 | ||
SMALLINT | (Signed) | 2 | -32768 | 32767 |
(Unsigned) | 0 | 65535 | ||
MEDIUMINT | (Signed) | 3 | -8388608 | 8388607 |
(Unsigned) | 0 | 16777215 | ||
INT | (Signed) | 4 | -2147483648 | 2147483647 |
(Unsigned) | 0 | 4294967295 | ||
BIGINT | (Signed) | 8 | -9223372036854770000 | 9223372036854770000 |
(Unsigned) | 0 | 18446744073709500000 |
'DB > MySQL' 카테고리의 다른 글
Error Code: 3 - Error writing file '/tmp/xxxxxxx (Errcode: 28) (0) | 2015.08.14 |
---|---|
mysql Errcode: 28 (0) | 2014.09.27 |
MySQL 서비스 등록 (0) | 2008.10.22 |
MySQL 에서 euc_kr.conf 이 없다고 할 때 (0) | 2007.07.16 |
DB존재 파악하고 없으면 DB테이블 생성 (0) | 2007.05.23 |