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:
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(100), EXP(180);
SELECT EXP(-10), EXP(-7);
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`;