mysql avg(currentPrice)如何取两位小数。

Question

mysql  avg(currentPrice)如何取两位小数。
currentPrice 字段是varchar(8)。

Answer 1

round 一下应该就可以了。mysql> select 1.234,round(1.234,2);
+-------+----------------+
| 1.234 | round(1.234,2) |
+-------+----------------+
| 1.234 |           1.23 |
+-------+----------------+
1 row in set (0.06 sec)mysql>

Answer 2

mysql> select currentPrice from t_lonelyriver;
+--------------+
| currentPrice |
+--------------+
| 1.23456      |
| 1.26776      |
| 1.26432      |
+--------------+
3 rows in set (0.00 sec)mysql> select avg(currentPrice),round(avg(currentPrice),2)
    -> from t_lonelyriver;
+-------------------+----------------------------+
| avg(currentPrice) | round(avg(currentPrice),2) |
+-------------------+----------------------------+
|  1.25554666666667 |                       1.26 |
+-------------------+----------------------------+
1 row in set (0.05 sec)mysql>