Подбор числового типа в таблице MYSQL

12.2.1 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT

MySQL supports the SQL standard integer typesINTEGER (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.

TypeStorageMinimum ValueMaximum Value
(Bytes)(Signed/Unsigned)(Signed/Unsigned)
TINYINT1-128127
 0255
SMALLINT2-3276832767
 065535
MEDIUMINT3-83886088388607
 016777215
INT4-21474836482147483647
 04294967295
BIGINT8-92233720368547758089223372036854775807
 018446744073709551615

Вход



Регистрация