MySQL integer: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT range _ MySQL

MySQL integer: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT range: bitsCN.com

MySQL integer: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT range

TINYINT: the signed range is-128 to 127, and the unsigned range is 0 to the power of 8.

SMALLINT: the signed range is-32768 to 32767, and the unsigned range is 0 to 65535, and the 16 power of 2

MEDIUMINT: the signed range is-8388608 to 8388607, and the unsigned range is 0 to 16777215,2's 24 power

INT (integer): The Signed range is-2147483648 to 2147483647. the unsigned range is 0 to the power of 32 of 4294967295 and 2.

BIGINT: the signed range is-9223372036854775808 to 9223372036854775807. the unsigned range is 0 to the power of.

BitsCN.com