Number Data types in MySQL : Integer Type « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Integer Type

Number Data types in MySQL

      

Data type        Acceptable values                  Storage requirements

TINYINT          Signed: -128 to 127                1 byte
                 Unsigned: 0 to 255
SMALLINT         Signed: -32768 to 32767            2 bytes
                 Unsigned: 0 to 65535
MEDIUMINT        Signed: -8388608 to 8388607        3 bytes
                 Unsigned: 0 to 16777215
INT              Signed: -2147483648 to 2147483647  4 bytes
                 Unsigned: 0 to 4294967295
INTEGER          INTEGER is a synonym for INT.      4 bytes

BIGINT           Signed: -9223372036854775808 to    8 bytes
                 9223372036854775807
                 Unsigned: 0 to 18446744073709551615








Related examples in the same category

1. Integer Types in MySQL with Sizes and Ranges
2.Int value: less than and equal
3.Int value: larger and equals
4.Int value: less than
5.Int value: bigger
6.INT(m), INTEGER(m): 32-bit integer (4 bytes, -2.147,483,648 to +2,147,483,647)
7.Compare with integer literal
8.Minus a constant value