MySQL 5.7-Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT整数类型(精确值)

MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each integer type.

MySQL支持SQL标准整数类型integer(或INT)和SMALLINT。作为标准的扩展，MySQL还支持TINYINT、MEDIUMINT和BIGINT整数类型。下表显示了每个整数类型所需的存储和范围。

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

MySQL支持的整数类型所需的存储和范围

Type	Storage (Bytes)	Minimum Value Signed	Minimum Value Unsigned	Maximum Value Signed	Maximum Value Unsigned
TINYINT	1	-128	0	127	255
SMALLINT	2	-32768	0	32767	65535
MEDIUMINT	3	-8388608	0	8388607	16777215
INT	4	-2147483648	0	2147483647	4294967295
BIGINT	8	-263	0	263-1	264-1