|
Data Type Description
TINYINT between 0 and 255 if UNSIGNED clause is applied; else the range is between -128 and 127.
SMALLINT between 0 and 65535 (UNSIGNED) or -32768 and 32767.
MEDIUM INT 0 to 16777215 with UNSIGNED clause or -8388608 and 8388607.
INT UNSIGNED between 0 and 4294967295 or -2147683648 and 2147683647.
BIGINT Huge numbers (-9223372036854775808 to 9223372036854775807).
FLOAT Floating point numbers (single precision).
DOUBLE Floating point numbers (double precision).
DECIMAL Floating point numbers represented as strings.
|