FLOAT(p) [UNSIGNED] [ZEROFILL] : FLOAT « Data Types « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Types
  3. FLOAT

A floating-point number.

p represents the precision in bits.

If p is from 0 to 24, the data type becomes FLOAT with no M or D values.

If p is from 25 to 53, the data type becomes DOUBLE with no M or D values.

10.11.FLOAT
10.11.1.FLOAT(p) [UNSIGNED] [ZEROFILL]
10.11.2.FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
10.11.3.For floating-point values, results are inexact: