EXP(X) returns the value of e (the base of natural logarithms) raised to the power of X : EXP « Math Numeric Functions « MySQL Tutorial






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

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

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

mysql>








21.17.EXP
21.17.1.EXP(X) returns the value of e (the base of natural logarithms) raised to the power of X
21.17.2.Using EXP function with data in a table