float double(浮点数) decimal(定点数)
(10, 5)第一位表示浮点数的位数,第二位表示小数点后的位数,
浮点数不加的话 默认数据不丢失,定点数不加的话默认为(10, 0)
mysql> select * from t2;
+--------------------+------+------+
| id1 | id2 | id3 |
+--------------------+------+------+
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
+--------------------+------+------+
5 rows in set (0.00 sec)
mysql> insert into t2 values(1.234, 1.234, 1.234);
Query OK, 1 row affected, 1 warning (0.01 sec)
mysql> select * from t2;
+--------------------+-------+------+
| id1 | id2 | id3 |
+--------------------+-------+------+
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.2300000190734863 | 1.23 | 1 |
| 1.234 | 1.234 | 1 |
+--------------------+-------+------+
6