MySQL EXP Function

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

SELECT EXP(X);

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

MySQL EXP Function Example

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

It also works on the column data. In this Mathematical method example, we are going to work on the Tax Amount and Service Grade columns.

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