The range of 1 and tinyint is-128 ~127;

2. Integer data (-2 3 1(-2 147 483 648) to 2 31–1(2147 483 647).

3.bigint ranges from -2 63 (-922372036854775808) to 263-1(922372036854775807) integer data (all numbers). The storage size is 8 bytes;

4. The range of small unsigned is–2 15 (215 stands for the power of 215) to 215–1,that is–32768 to 32767;

5. The range of 5.smallint is 0 to 216–1,that is, 0 to 65535, and the stored bytes are 2 bytes.

Extended data

Int type, the number of bytes occupied is 4 bytes. Students who have studied computer principles should know that bytes are not the smallest unit of computer storage, and there are smaller units than bytes, that is, bits, where one bit represents a 0 or1; 8 bits make up a byte; Usually, bytes are represented by capital letter B, and bits are represented by lowercase letter B. ..

Conversion of computer storage unit;

1B=8b

1KB= 1024B

1MB= 1024KB

Then the number of bytes allowed to be stored according to the int type is 4 bytes. Can int be converted? The UNSIGNED type can store a minimum value of 0 and a maximum value of 4294967295 (that is, 4B=32b, and the maximum value consists of 32 1).