MySQL EXP function is one of the Mathematical Function which is used to return E raised to the power of given value. Here, E is the base of natural logarithm.
In this article, we will show you, How to find EXP values in MySQL using Command Prompt, and Workbench with examples.
MySQL EXP Syntax
The syntax of the EXP in MySQL is as shown below:
This function find and retunes e raised to the power of X.
MySQL EXP Function Example 1
The following query will show multiple ways to use EXP function. Within the third statement, we used the 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 Tax Amount and Service Grade columns.
FROM `MySQL Tutorial`.`mathemetical functions`;
Thank You for Visiting Our Blog