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 |