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.
MySQL EXP Syntax
The syntax of the EXP in MySQL is as shown below:
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 statement, we used negative values.
SELECT EXP(100), EXP(180);
SELECT EXP(-10), EXP(-7);
MySQL EXP Example 2
The EXP function also works on the column data. In this example, we are going to find the EXP value of the Tax Amount and Service Grade columns.
FROM `MySQL Tutorial`.`mathemetical functions`;