MySQL supports the SQL standard integer types INTEGER (or INT ) and SMALLINT . As an extension to the standard, MySQL also supports the integer types TINYINT , MEDIUMINT , and BIGINT . The following table shows the required storage and range for each integer type.

Table 11.1 Required Storage and Range for Integer Types Supported by MySQL

Storage (Bytes) Minimum Value Signed Minimum Value Unsigned Maximum Value Signed Maximum Value Unsigned TINYINT SMALLINT -32768 32767 65535 MEDIUMINT -8388608 8388607 16777215 -2147483648 2147483647 4294967295 BIGINT -2 63 2 63 -1 2 64 -1