
Ispirer SQLWays Database Migration Software
FLOAT
FLOAT[(p[,s])] [UNSIGNED]
A floatingpoint number. Precision p can be <=24 for a singleprecision floatingpoint number (allowable values are 3.402823466E+38 to 1.175494351E38, 0, and 1.175494351E38 to 3.402823466E+38) and between 25 and 53 for a doubleprecision floatingpoint number.
The p is the precision, or the total number of digits. The s is the scale, or the number of digits to the right of the decimal point.
FLOAT without arguments stands for a singleprecision floatingpoint number. In MySQL Version 3.23, this is a true floatingpoint value. In earlier MySQL versions, FLOAT(p) always has 2 decimals. All calculations in MySQL are done with double precision.
If UNSIGNED is specified, negative values are not allowed.