Mega Code Archive

 

Categories / MySQL Tutorial / Math Numeric Functions

 

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>