Skip to content

EXP()

Function Description

The EXP(number) function returns the exponent of number with the natural constant e as the base.

Function Syntax

> EXP(number)

Parameter definition

Parameters Description
number Required parameters, any numerical data type can be taken

Example

drop table if exists t1;
create table t1(a int ,b float);
insert into t1 values(-4, 2.45);
insert into t1 values(6, -3.62);

mysql> select exp(a), exp(b) from t1;
+------------------------------------------------------------------------------------------------------------------------------
| exp(a) | exp(b) |
+------------------------------------------------------------------------------------------------------------------------------
| 0.01831563888873418 | 11.588347271798835 |
| 403.4287934927351 | 0.026782679557672436 |
+------------------------------------------------------------------------------------------------------------------------------
2 rows in set (0.00 sec)