1 bytes = 8 bit, a byte can represent a maximum of 2 of the data length is 8 square-128 to 127, unsigned from 0 to 255 of the integer data.
Tinyint[(M)] [UNSIGNED] [Zerofill] M default is 4
A small integer with a storage size of 1 bytes. The signed range is -2^7 (-128) to 2^7-1 (-128 to 127). The unsigned range is 0 to 255.
Smallint[(M)] [UNSIGNED] [Zerofill] M default is 6
A small integer with a storage size of 2 bytes. The signed range is from -2^15 (-32,768) to 2^15-1 (-32768 to 32767). The unsigned range is 0 to 65535.
Mediumint[(M)] [UNSIGNED] [Zerofill] M default is 9
A medium-sized integer with a storage size of 3 bytes. The signed range is 8388608 to 8388607. The unsigned range is 0 to 16777215.
Int[(M)] [UNSIGNED] [Zerofill] M default is 11
An integer of normal size with a storage size of 4 bytes. The signed range is from -2^31 (-2,147,483,648) to 2^31-1 (-2147483648 to 2147483647). The unsigned range is 0 to 4294967295.
bigint[(M)] [UNSIGNED] [Zerofill]M default is 20
A large integer with a storage size of 8 bytes. The signed range is -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (-9223372036854775808 to 9223372036854775807). The unsigned range is 0 to 18446744073709551615.
The differences between tinyint, smallint, mediumint,int, and bigint in MySQL
