MySQL three floating-point types

The three floating-point types supported by MySQL are the float, DOUBLE, and DECIMAL types.

The float value type is used to represent a single-precision floating point value
Double numeric types are used to represent double-precision floating-point numbers.

As with integers, these types also have additional parameters: a display width indicator and a decimal point indicator. For example, the statement FLOAT (7,3) specifies that the value displayed will not exceed 7 digits, followed by a 3-digit number after the decimal point.

The UNSIGNED and Zerofill modifiers can also be used by the FLOAT, DOUBLE, and DECIMAL data types. And the effect is the same as the INT data type.

MySQL three floating-point types