FLOAT(10,3) : Float « Data Type « SQL / MySQL

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

FLOAT(10,3)

    
mysql>
mysql> CREATE TABLE MEASUREMENTS
    ->       (NR INTEGER, MEASUREMENT_VALUE FLOAT(10,3))
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO MEASUREMENTS VALUES
    ->    (1, 99.99),
    ->    (2, 99999.99),
    ->    (3, 99999999.99),
    ->    (4, 99999999999.99),
    ->    (5, 99999999999999.99),
    ->    (6, 0.999999),
    ->    (7, 0.9999999),
    ->    (8, 99999999.9999),
    ->    (9, (1.0/3))
    -> ;
Query OK, 9 rows affected, 4 warnings (0.00 sec)
Records: 9  Duplicates: 0  Warnings: 4

mysql> SELECT * FROM MEASUREMENTS;
+------+-------------------+
| NR   | MEASUREMENT_VALUE |
+------+-------------------+
|    1 |            99.990 |
|    2 |         99999.992 |
|    3 |      10000000.000 |
|    4 |      10000000.000 |
|    5 |      10000000.000 |
|    6 |             1.000 |
|    7 |             1.000 |
|    8 |      10000000.000 |
|    9 |             0.333 |
+------+-------------------+
9 rows in set (0.00 sec)

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

mysql>

   
    
    
    
  

Related examples in the same category