how to set float type in mysql 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: mysql float
column_name DECIMAL(precision, scale)
-- DECIMAL stores exact numeric values with a fixed decimal point.
-- The precision is the total number of digits before AND after the decimal point.
-- The scale is the number of digits after the decimal point.