# MySQL EXP() function

## EXP() function

MySQL EXP() returns the value of the base of natural logarithm number e, raised to the power of a number specified as argument.

This function is useful in -

• The EXP() function allows for easy calculations involving 'e'.
• The EXP() function is a vital tool in calculus for solving differential equations, particularly those involving exponential growth and decay.
• The EXP() function is used in ecology and demography to model populations, especially in scenarios where births and deaths occur continuously.
• In finance and investment analysis, the EXP() function is used to make projections about the future value of investments, taking into account compounding.
• In probability theory and statistics, the EXP() function is used to model continuous random variables with an exponential distribution.
• The constant 'e' is a fundamental mathematical constant that arises in many areas of mathematics and science.

Syntax:

```EXP(N);
```

Argument:

Name Description
N A number.

Syntax Diagram:

MySQL Version: 8.0

Pictorial presentation of MySQL EXP() function

Example of MySQL EXP() function

Code:

``````SELECT EXP(1);
```
```

Explanation:

The above MySQL statement will return the value of the natural logarithm base number e raised to the power of the given number.

Output:

```mysql> SELECT EXP(1);
+------------------+
| EXP(1)           |
+------------------+
| 2.71828182845905 |
+------------------+
1 row in set (0.03 sec)
```

Example: EXP() function with negative value

Code:

``````SELECT EXP(-1);
```
```

Explanation:

The above MySQL statement will return the value of the natural logarithm base number e raised to the power of the given number.

Output:

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

All Mathematical Functions

Previous: DIVISION
Next: FLOOR()

﻿

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/mysql/mathematical-functions/mysql-exp-function.php