MySQL integer Types (Exact Value)-Integer, INT, SMALLINT, TINYINT, Mediumint, BIGINT

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