Type Name Value Range Unsigned
TINYINT-128 to 1270-255
SMALLINT-32768 to 327670-65535
MEDIUMINT-8388608 to 83886070-16777215
INT-2147483648 to 21474836470-4294967295
BIGINT-9223372036854775808 - 92233720368547758070-18446744073709551615
FLOAT(M,D)Varies depending on valuesVaries depending on values
DOUBLE(M,D)Varies depending on valuesVaries depending on values
DECIMAL(M,D)Varies depending on valuesVaries depending on values
If the column is numeric and declared UNSIGNED, the range doubles for the given type.
FLOATs, DOUBLEs, and DECIMALs can hold fractions.
The other types cannot.
The first number is the number of digits for the whole number and the second is the number of digits for the fraction.
You can limit the number of digits to the right of the decimal point.
For 5.6876, FLOAT(4,2) type column would store 5.69.
FLOAT(4,3) would be store 5.688.
MySQL rounds the decimal to fit the number of digits right of the decimal point.