MySQL :: MySQL 8.4 Reference Manual :: 13.1.2 Integer Types (Exact Value) MEDIUMINT, BIGINT (original) (raw)
The world's most popular open source database
13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
MySQL supports the SQL standard integer typesINTEGER (or INT) andSMALLINT. As an extension to the standard, MySQL also supports the integer typesTINYINT, MEDIUMINT, andBIGINT. The following table shows the required storage and range for each integer type.
Table 13.1 Required Storage and Range for Integer Types Supported by 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 |