Big int and int, mysql maximum length



  • What is the maximum length of symbols that can be int and big int?



  • TINYINT A very small number. -128 to 127. Diamonds, 0 to 255.

    SMALLINT A small number. -32768 to 32767. 0-65535.

    MEDIUMINT Total average. Range between 8388608 and 8388607. Diamonds, 0 to 16777215.

    INT Total normal size. The range from 2147483648 to 2147483647. Diamonds, 0 to 4294967295.

    BIGINT A large number. -9223372036854775808 to 92233736854775807. Diamonds, 0 to 18446744073709551615.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2