mysql double保留两位小数_mysql数据库中计算时如何保留两位小数呢?
摘要:下文讲述mysql数据库中数值计算时保留两位小数的方法分享,如下所示:例:mysql > select convert(9521,decimal(12,2));+-----------------------------+| convert(9521,decimal(12,2)) |+-----------------------------+|...
摘要:
下文讲述mysql数据库中数值计算时保留两位小数的方法分享,如下所示:
例:
mysql > select convert(9521,decimal(12,2));
+-----------------------------+
| convert(9521,decimal(12,2)) |
+-----------------------------+
| 9521.00 |
+-----------------------------+
1 row in set (0.00 sec)
mysql> select convert(8875.123,decimal(12,2));
+---------------------------------+
| convert(8875.123,decimal(12,2)) |
+---------------------------------+
| 8875.12 |
+---------------------------------+
1 row in set (0.00 sec)
mysql> select convert(6523.136,decimal(12,2));
+---------------------------------+
| convert(6523.136,decimal(12,2)) |
+---------------------------------+
| 6523.14 |
+---------------------------------+
1 row in set (0.00 sec)
更多推荐
所有评论(0)