Data type Acceptable values Storage requirements
TINYINT Signed: -128 to 127 1 byte
Unsigned: 0 to 255
SMALLINT Signed: -32768 to 32767 2 bytes
Unsigned: 0 to 65535
MEDIUMINT Signed: -8388608 to 8388607 3 bytes
Unsigned: 0 to 16777215
INT Signed: -2147483648 to 2147483647 4 bytes
Unsigned: 0 to 4294967295
INTEGER INTEGER is a synonym for INT. 4 bytes
BIGINT Signed: -9223372036854775808 to 8 bytes
9223372036854775807
Unsigned: 0 to 18446744073709551615