MySQL EXP Function

MySQL EXP function is one of the Mathematical functions used to return E raised to the power of given value. In this MySQL EXP calculation, E is the base of the natural logarithm. The syntax of the EXP in MySQL is as shown below:

SELECT EXP(X);

This EXP function finds and retunes e raised to the power of X.

MySQL EXP Function Example 1

The following query shows multiple ways to use the EXP function. Within the third MySQL statement, we used negative values.

SELECT EXP(0);

SELECT EXP(100), EXP(180);

SELECT EXP(-10), EXP(-7);
MySQL EXP Function 1

MySQL EXP Example 2

The EXP function also works on the column data. In this Mathematical Function example, we are going to find the EXP value of the Tax Amount and Service Grade columns.

SELECT EnglishProductName, 
Color,
      SalesAmount,
      TaxAmt,
      EXP(TaxAmt),
      `Service Grade`,
      EXP(`Service Grade`)
 FROM `MySQL Tutorial`.`mathemetical functions`;
MySQL EXP Function 2