四舍五入精度丢失
mysql> SELECT ROUND('164.85', 1), ROUND(164.85, 1);
+--------------------+------------------+
| ROUND('164.85', 1) | ROUND(164.85, 1) |
+--------------------+------------------+
| 164.8 | 164.9 |
+--------------------+------------------+
1 row in set (0.03 sec)
将字符串 164.85
转为Decimal在进行四舍五入
mysql> SELECT ROUND(CAST('164.85' AS DECIMAL(10, 2)), 1), ROUND('164.85', 1), ROUND(164.85, 1);
+--------------------------------------------+--------------------+------------------+
| ROUND(CAST('164.85' AS DECIMAL(10, 2)), 1) | ROUND('164.85', 1) | ROUND(164.85, 1) |
+--------------------------------------------+--------------------+------------------+
| 164.9 | 164.8 | 164.9 |
+--------------------------------------------+--------------------+------------------+
1 row in set (0.04 sec)