MySQL tinyint smallint mediumint int bigint

Type	Space occupied by storage (no matter how many bits are displayed) (Unit byte/bytes)	Storing data ranges	Maximum display length
tinyint	1	-128 ~ 127 Signed 0 ~ 255 Unsigned	3
Smaillint	2	-32768 ~ 32767 Signed 0 ~ 65535 unsigned	5
Mediumint	3	-8388608 ~ 8388607 Signed 0 ~ 16777215 Unsigned	7 signed 8 unsigned
Int	4	-2147483648 ~ 2147483647 Signed 0 ~ 4294967295 Unsigned	11
bigint	8	-9223372036854775808 ~ 9223372036854775807 Signed 0 ~ 18446744073709551615 Unsigned	Signed Unsigned

Create   TableMysql_int (IDint( One)Primary Keyauto_increment,tinyint_atinyint(3) not NULL, Smallint_bsmallintUnsigned not NULL, Mediumint_c mediumint (7) not NULL, Bigint_dbigintUnsigned not NULL);

MySQL tinyint smallint mediumint int bigint