Range of values for bigint, int, mediumint, smallint and tinyint in MySQL

74277381

MySQL database design, where the performance optimization, field type is very important, the following bigint, int, mediumint, smallint and tinyint range of values for a simple summary, for viewing.

1, bigint

Integer data (all numbers) from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807), the unsigned range is 0 to 18446744073709551615. A one is 8 bytes.

2, int

A normal size integer. The signed range is the integer data (all numbers) of -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647), and the unsigned range is 0 to 4294967295. A size of 4 bytes.
The SQL-92 synonym for int is integer.

3, Mediumint

A medium-sized integer with a signed range of 8388608 to 8388607, and an unsigned range of 0 to 16777215. A size of 3 bytes.

4, smallint

A small integer. The signed range is the integer data of -2^15 (-32,768) to 2^15-1 (32,767), and the unsigned range is 0 to 65535. A size of 2 bytes. MySQL provides more than enough functionality, and because MySQL is open source software, it can significantly reduce TCO.

5, tinyint

The signed range is-128-127, and the unsigned range is the integer data from 0 to 255. One size is 1 bytes.

Range of values for bigint, int, mediumint, smallint and tinyint in MySQL