MySQL supports the SQL standard integer types MySQL支持SQL标准整数类型INTEGER
(or INT
) and SMALLINT
. INTEGER
(或INT
)和SMALLINT
。As an extension to the standard, MySQL also supports the integer types 作为标准的扩展,MySQL还支持整数类型TINYINT
, MEDIUMINT
, and BIGINT
. TINYINT
、MEDIUMINT
和BIGINT
。The following table shows the required storage and range for each integer type.下表显示了每个整数类型所需的存储和范围。
Table 11.1 Required Storage and Range for Integer Types Supported by MySQLMySQL支持的整数类型所需的存储和范围
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 |