1column_name DECIMAL(precision, scale)
2-- DECIMAL stores exact numeric values with a fixed decimal point.
3-- The precision is the total number of digits before AND after the decimal point.
4-- The scale is the number of digits after the decimal point.
1FLOAT(P)
2 where P is precision 0 to 53
3FLOAT(M,D)
4 where M is the total number of digits and D is the number of digits after the decimal point