totn MariaDB Functions

MariaDB: EXP Function

This MariaDB tutorial explains how to use the MariaDB EXP function with syntax and examples.

Description

The MariaDB EXP function returns e raised to the power of number (or enumber).

Syntax

The syntax for the EXP function in MariaDB is:

EXP( number )

Parameters or Arguments

number
The power to raise e to, so the formula would be enumber.

Note

  • e is the base of natural logarithms.
  • See also the LOG and LN functions.

Applies To

The EXP function can be used in the following versions of MariaDB:

  • MariaDB 10

Example

Let's look at some MariaDB EXP function examples and explore how to use the EXP function in MariaDB.

For example:

SELECT EXP(3);
Result: 20.085536923187668

SELECT EXP(2);
Result: 7.38905609893065

SELECT EXP(2.5);
Result: 12.182493960703473

SELECT EXP(-2.5);
Result: 0.0820849986238988