Curriculum
Course: MYSQL
Login

Curriculum

MYSQL

MySQL References

0/140
Text lesson

EXP

Example

Provide the result of raising Euler’s number (e) to the power of 1.

SELECT EXP(1); 

Definition and Usage

The EXP() function yields the value of Euler’s number (e) raised to the power of the given number. The constant e (approximately 2.718281…) serves as the base for natural logarithms.

Tip: Consider also the LOG() and LN() functions.

Syntax

EXP(number)

Parameter Values

Parameter

Description

number

Necessary: The exponent value is required.

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Provide the result of raising Euler’s number (e) to the power of 2.

SELECT EXP(2);