mysql as float code example

Example 1: float mysql

FLOAT(P) 
  where P is precision 0 to 53
FLOAT(M,D) 
  where M is the total number of digits and D is the number of digits after the decimal point

Example 2: cast float mysql

SELECT
    integer_column + 0.0 AS float_column