![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
FLOAT
FLOAT[(p[,s])] [UNSIGNED]
A floating-point number. Precision p can be <=24 for a single-precision floating-point number (allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38) and between 25 and 53 for a double-precision floating-point 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 single-precision floating-point number. In MySQL Version 3.23, this is a true floating-point 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.
![]() ![]() ![]() |