When using MySQL, there are many types of int that need to be noted:
1. Range of values
Type |
Storage |
Minimum Value |
Maximum Value |
| (
Bytes) | (
signed/unsigned | ) (
signed/unsigned) |
TINYINT |
1 |
-128 |
127 |
|
|
0 |
255 |
SMALLINT |
2 |
-32768 |
32767 |
|
|
0 |
65535 |
MEDIUMINT |
3 |
-8388608 |
8388607 |
|
|
0 |
16777215 |
INT |
4 |
-2147483648 |
2147483647 |
|
|
0 |
4294967295 |
BIGINT |
8 |
-9223372036854775808 |
9223372036854775807 |
|
|
0 |
18446744073709551615 |
2. Display width
MySQL also supports the selection of the display width of the specified integer value within the parentheses following the type keyword.
Int (m) in the integer data type, m represents the maximum display width, and the optional display width specifies that the width is filled from the left when the value of the width less than the specified column width is displayed.
Reference documents:
Https://dev.mysql.com/doc/refman/5.5/en/integer-types.html
MySQL integer Types (Exact Value)-Integer, INT, SMALLINT, TINYINT, Mediumint, BIGINT