FLOAT(m, d): Floating-point number, 8-place accuracy (4 byte); : Float « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Float

FLOAT(m, d): Floating-point number, 8-place accuracy (4 byte);

   

The optional values m and d give the desired number of places before and after the decimal point in SELECT
results; these values have no influence on the actual way the numbers are stored.


mysql>
mysql> CREATE TABLE a (
    ->  id INT NOT NULL AUTO_INCREMENT,
    ->  choice FLOAT,
    ->  PRIMARY KEY (id));
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql> drop table a;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1.FLOAT(10,3)
2.Float type column type
3.FLOAT(19,3) ZEROFILL
4.A table definition that uses the DECIMAL and FLOAT data types.