DB/MySQL
mysql table 필드 타입 별 스토리지 사용량 및 최대값
단독질주
2007. 5. 23. 18:33
| 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 | ||