| Data Type | Storage | Min/Max Values |
|---|---|---|
| TINYINT | 1 byte | Signed: -128 to 127 Unsigned: 0 to 255 |
| SMALLINT | 2 bytes | Signed: -32,768 to 32,767 Unsigned: 0 to 65,535 |
| MEDIUMINT | 3 bytes | Signed: -8,388,608 to 8,388,607 Unsigned: 0 to 16,777,215 |
| INT | 4 bytes | Signed: -2,147,483,648 to 2,147,483,647 Unsigned: 0 to 4,294,967,295 |
| BIGINT | 8 bytes | Signed: -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Unsigned: 0 to 18,446,744,073,709,551,615 |
| FLOAT | 4 bytes | |
| DOUBLE | 8 bytes | |
| YEAR | 1 byte | |
| DATE | 3 bytes | |
| TIME | 3 bytes | |
| DATETIME | 8 bytes | |
| TIMESTAMP | 4 bytes |