MySQL Field Types
Mysql supports a number of column types, which may be grouped into three categories: numeric types, date and time types, and string (character) types. This section first gives an overview of the types available. Please refer to the MySQL manuals for more details. Type Use for Size TINYINT A very small integer The signed range is – 128 to 127. The unsigned range is 0 to 255. SMALLINT A small integer The signed range is – 32768 to 32767. The unsigned range is 0 to 65535 MEDIUMINT A medium-size integer The signed range is – 8388608 to 8388607. The unsigned range is 0 to 16777215 INT or INTEGER A normal-size integer The signed range is – 2147483648 to 2147483647. The unsigned range is 0 to 4294967295 BIGINT A large integer The signed range is – 9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615 FLOAT A small (s