Jump to: navigation, search

Mysql EXP

From w3cyberlearnings

Contents

MySQL EXP Function

This function returns the value of e raised to the power of X, and it is based on the natural logarithms. It's reverse function is LOG() or LN(). It returns the exponent of e.

Syntax EXP

X is an integer.

EXP(X);

Example 1

mysql> SELECT EXP(2);
+------------------+
| EXP(2)           |
+------------------+
| 7.38905609893065 |
+------------------+
1 row in set (0.00 sec)

Example 2

mysql> SELECT EXP(0);
+--------+
| EXP(0) |
+--------+
|      1 |
+--------+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References