Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

MySQL EXP() Function

Concept visual

MySQL EXP() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return e

raised to the power of 1:

SELECT EXP(1);

Definition and Usage

The EXP() function returns e

raised to the power of the specified number.

The constant e

(2.718281...), is the base of natural logarithms.

Tip:

Also look at the LOG()

and

Ln()

functions.

Syntax

Exp(

number )

Parameter Values

Parameter

Description number

Required. The power number

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return e

raised to the power of 2:

SELECT EXP(2);

MySQL EXP() Function

Concept visual

MySQL EXP() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return e

raised to the power of 1:

SELECT EXP(1);

Definition and Usage

The EXP() function returns e

raised to the power of the specified number.

The constant e

(2.718281...), is the base of natural logarithms.

Tip:

Also look at the LOG()

and

Ln()

functions.

Syntax

Exp(

number )

Parameter Values

Parameter

Description number

Required. The power number

Technical Details

Works in:

From MySQL 4.0

More Examples

Example

Return e

raised to the power of 2:

SELECT EXP(2);

MySQL EXP() Function

MySQL EXP() Function

Example

Return e

Definition and Usage

The EXP() function returns e

The constant e

Tip:

Also look at the LOG()

Ln()

Syntax

Exp(

Parameter Values

Parameter

Description number

Technical Details

Works in:

More Examples

Example

Return e

Previous

Next

MySQL EXP() Function

MySQL EXP() Function

Example

Return e

Definition and Usage

The EXP() function returns e

The constant e

Tip:

Also look at the LOG()

Ln()

Syntax

Exp(

Parameter Values

Parameter

Description number

Technical Details

Works in:

More Examples

Example

Return e

Previous

Next