MySQL Data Types Integer Types
Example
Minimal unsigned value is always 0.
| Type | Storage (Bytes) | Minimum Value (Signed) | Maximum Value (Signed) | Maximum Value (Unsigned) |
|---|---|---|---|---|
TINYINT | 1 | -27 -128 | 27-1 127 | 28-1 255 |
SMALLINT | 2 | -215 -32,768 | 215-1 32,767 | 216-1 65,535 |
MEDIUMINT | 3 | -223 -8,388,608 | 223-1 8,388,607 | 224-1 16,777,215 |
INT | 4 | -231 -2,147,483,648 | 231-1 2,147,483,647 | 232-1 4,294,967,295 |
BIGINT | 8 | -263 -9,223,372,036,854,775,808 | 263-1 9,223,372,036,854,775,807 | 264-1 18,446,744,073,709,551,615 |
