- 论坛徽章:
- 9
|
原帖由 也是菜鸟 于 2009-11-3 12:21 发表
是的
列类型是float形的
mysql> create table msum (`num` float);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into msum values(1);
Query OK, 1 row affected (0.00 sec)
mysql> insert into msum values(2);
Query OK, 1 row affected (0.00 sec)
mysql> insert into msum values(3);
Query OK, 1 row affected (0.00 sec)
mysql> insert into msum values(4);
Query OK, 1 row affected (0.00 sec)
mysql> select sum(`num`) from msum;
+------------+
| sum(`num`) |
+------------+
| 10 |
+------------+
1 row in set (0.00 sec)
|
我这里是ok的,估计是你插入的时候数据就有一定的偏差,导致数据库的数据就带有小数了 |
|