Movatterモバイル変換

MySQL 9.1 Reference Manual

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

MySQL supports the SQL standard integer typesINTEGER (orINT) andSMALLINT. As an extension to the standard, MySQL also supports the integer typesTINYINT,MEDIUMINT, andBIGINT. The following table shows the required storage and range for each integer type.

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

Type	Storage (Bytes)	Minimum Value Signed	Minimum Value Unsigned	Maximum Value Signed	Maximum Value Unsigned
`TINYINT`	1	`-128`	`0`	`127`	`255`
`SMALLINT`	2	`-32768`	`0`	`32767`	`65535`
`MEDIUMINT`	3	`-8388608`	`0`	`8388607`	`16777215`
`INT`	4	`-2147483648`	`0`	`2147483647`	`4294967295`
`BIGINT`	8	`-2⁶³`	`0`	`2⁶³-1`	`2⁶⁴-1`

PREV HOME UP NEXT