The MySQL 8 numeric data types include integer or exact data types, decimal or approximate data types, and bit data types.
Numeric data types
Integer types
All standard SQL integer types are supported by MySQL.
The following is a table describing the required storage and range for each integer type. Along with standard integer data types, MySQL also supports TINYINT, MEDIUMINT, and BIGINT:
Type
|
Storage (Bytes)
|
Minimum Value
|
Maximum Value
|
Signed / Unsigned
|
Signed / Unsigned
|
||
TINYINT | 1 | -128 | 127 |
0 | 255 | ||
SMALLINT | ...