共计 317 个字符,预计需要花费 1 分钟才能阅读完成。
Integer type (Exact Value)
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^63 | 0 | 2^63-1 | 2^64-1 |
- int 类型占用 4 个字节
- 参考:https://dev.mysql.com/doc/ref…
正文完