MySQL数学函数简明总结(10)

mysql> select EXP(3), EXP(0), EXP(-3);
+-------------------+--------+---------------------+
| EXP(3)            | EXP(0) | EXP(-3)             |
+-------------------+--------+---------------------+
| 20.08553692318767 |      1 | 0.04978706836786393 |
+-------------------+--------+---------------------+

13. LOG(X)和LOG10(X): 对数运算函数（Ｘ必须为正数），LOG(X)-返回Ｘ的自然对数(X相对于基数e的对数)　LOG10(X)-返回x的基数为10的对数：

复制代码 代码如下:

mysql> select LOG(-3), LOG(0), LOG(3), LOG10(-100), LOG10(0), LOG10(100);
+---------+--------+--------------------+-------------+----------+------------+
| LOG(-3) | LOG(0) | LOG(3)             | LOG10(-100) | LOG10(0) | LOG10(100) |
+---------+--------+--------------------+-------------+----------+------------+
|    NULL |   NULL | 1.0986122886681098 |        NULL |     NULL |          2 |
+---------+--------+--------------------+-------------+----------+------------+

14. RADIANS(X) 和 DEGREES(X): 角度与弧度转换函数

复制代码 代码如下: