Math Numeric Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Math Numeric Functions
  4. EXP(X) returns the value of e (the base of natural logarithms) raised to the power of X
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>