[MySQL] INT 자료형 (TINYINT / SMALLINT / MEDIUMINT / INT / BIGINT)

매번 검색하기 귀찮아서 퍼옴 ㅎㅎ

Table 11.1 Required Storage and Range for Integer Types Supported by MySQL

Type	Storage (Bytes)	최소값 (signed)	최소값 (unsigned)	최대값 (signed)	최대값 (unsigned)
TINYINT	1	-128	0	127	255
SMALLINT	2	-32768	0	32767	65535
MEDIUMINTINT	3	-8388608	0	8388607	16777215
INT	4	-2147483648	0	2147483647	4294967295
BIGINT	8	-2^63	0	2^63 - 1	2^64 - 1

 

* 출처 : https://dev.mysql.com/doc/refman/8.0/en/integer-types.html