Mega Code Archive

 

Categories / MySQL / Data 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