본문 바로가기

DB/MySQL

mysql table 필드 타입 별 스토리지 사용량 및 최대값

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