EXP()

Description

The EXP() function returns the value of e (the base of natural logarithms) raised to the power of X.

Syntax

  1. > EXP(number)

Arguments

ArgumentsDescription
numberRequired. Any numeric data type supported now.

Examples

  1. drop table if exists t1;
  2. create table t1(a int ,b float);
  3. insert into t1 values(-4, 2.45);
  4. insert into t1 values(6, -3.62);
  5. mysql> select exp(a), exp(b) from t1;
  6. +---------------------+----------------------+
  7. | exp(a) | exp(b) |
  8. +---------------------+----------------------+
  9. | 0.01831563888873418 | 11.588347271798835 |
  10. | 403.4287934927351 | 0.026782679557672436 |
  11. +---------------------+----------------------+
  12. 2 rows in set (0.00 sec)