LOG()

Function Description

The LOG(X) function returns the natural logarithm of X.

Function Syntax

> LOG(X)

Parameter definition

Parameters	Description
X	Required parameters, any currently supported numerical data

Example

drop table if exists t1;
create table t1(a float, b float);
insert into t1 values(2,8);

mysql> select log(a), log(b) from t1;
+------------------------------------------------------------------------------------------------------------------------------
| log(a) | log(b) |
+------------------------------------------------------------------------------------------------------------------------------
| 0.6931471805599453 | 2.0794415416798357 |
+------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

limit

LOG(X) currently only supports single-parameter input.