ID EN
Mathematical Functions

EXP(X)

MySQL 8.4

Returns the value of e (the base of natural logarithms) raised to the power of X. The inverse of this function is LOG() (using a single argument only) or LN().

Syntax

MYSQL
SELECT EXP(2);
7.3890560989307
SELECT EXP(-2);
0.13533528323661
SELECT EXP(0);
1

Examples

Example

If X is NULL, this function returns NULL.

MYSQL
SELECT EXP(2);
7.3890560989307
SELECT EXP(-2);
0.13533528323661
SELECT EXP(0);
1