mysql---数值函数

1,abs

mysql> select abs(0.0), abs(0.8), abs(-0.8);
+----------+----------+-----------+
| abs(0.0) | abs(0.8) | abs(-0.8) |
+----------+----------+-----------+
|      0.0 |      0.8 |       0.8 |
+----------+----------+-----------+
1 row in set (0.00 sec)

取绝对值
2， ceil

mysql> select ceil(-0.8), (0.8);
+------------+-----+
| ceil(-0.8) | 0.8 |
+------------+-----+
|          0 | 0.8 |
+------------+-----+
1 row in set (0.01 sec)

大于数值的最小整数
3，floor

mysql> select floor(0.8), floor(-0.8);
+------------+-------------+
| floor(0.8) | floor(-0.8) |
+------------+-------------+
|          0 |          -1 |
+------------+-------------+
1 row in set (0.00 sec)

小于数值的最大整数
4，mod

mysql> select mod(2, 3), mod(3, 2);
+-----------+-----------+
| mod(2, 3) | mod(3, 2) |
+-----------+-----------+
|         2 |         1 |
+-----------+-----------+
1 row in set (0.00 sec)

2除以3的余数为2， 3除以2的余数为3。
5，rand

mysql> select rand(), rand();
+--------------------+-----------------------+
| rand()             | rand()                |
+--------------------+-----------------------+
| 0.5458060247318876 | 0.0077994242383161785 |
+--------------------+-----------------------+
1 row in set (0.00 sec)

0到1之间的随机数
6,round();

mysql> select round(3.0, 3);
+---------------+
| round(3.0, 3) |
+---------------+
|         3.000 |
+---------------+
1 row in set (0.00 sec)

3.0 保留3位小数的四舍五入
7,truncate

mysql> select truncate(3.23456, 4);
+----------------------+
| truncate(3.23456, 4) |
+----------------------+
|               3.2345 |
+----------------------+
1 row in set (0.00 sec)

3.23456保留4位小数截取，不进行四舍五入