乐趣区

关于mysql:mysqlDataTypes

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…
退出移动版