Mysql中取整函数
- floor是一个向下取整[不大于该数的最大整数]的函数
mysql> select floor(2.3);
+------------+
| floor(2.3) |
+------------+
| 2 |
+------------+
1 row in set (0.00 sec)
mysql> select floor(2.8);
+------------+
| floor(2.8) |
+------------+
| 2 |
+------------+
1 row in set (0.00 sec)
- round是一个四舍五入的函数
mysql> select round(2.8);
+------------+
| round(2.8) |
+------------+
| 3 |
+------------+
1 row in set (0.00 sec)
mysql> select round(2.2);
+------------+
| round(2.2) |
+------------+
| 2 |
+------------+
1 row in set (0.00 sec)