摘要:
下文讲述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)