The range and storage size of all types of int in MySQL

The integer type int in MySQL is mainly as follows:

The range of tinyint is -128~127;

int ranges from -2^31 (-2,147,483,648) to 2^31–1 (2,147,483,647) for integer data (all numbers), with a storage size of 4 bytes;

The bigint range is the integer data (all numbers) of -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807). The storage size is 8 bytes;

The range of smallint unsigned is –2^15 (2^15 represents 2 of 15 powers) to 2^15–1, i.e. –32768 to 32767;

The smallint range is 0 to 2^16–1, which is 0 to 65535, and the bytes stored are 2 bytes.

We should be careful when designing to use smaller data types whenever possible.

The range and storage size of all types of int in MySQL