Mega Code Archive
FLOAT(10,3)
<![CDATA[
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>
]]>