Site icon

MySQL Mathematical Functions


In this tutorial, we will learn about MySQL mathematical functions with examples. MySQL supports many built-in functions. Mathematical functions are a type of function mostly used for mathematical calculations.

MySQL Mathematical Functions

Some MySQL mathematical functions are as follows:

Numeric Function


This function returns the value of e raised to the power of X.
The inverse of this function is LOG().
LN(X) This function returns the natural logarithm (the base-e logarithm) of X.
LOG(B,X) This function returns the logarithm of the base B of X.
LOG2(X) This function returns the base-2 logarithm of X.
LOG10(X)  This function returns the base-10 logarithm of X.
POWER(X,Y) or POW This function returns the value of X raised to the power of Y.
SQRT(X) This function returns the square root of X.
MOD(N,M) This function returns the remainder of N divided by M.(the Modulo operation. )



mysql> SELECT EXP(1);
| EXP(1) |
| 2.718281828459045 |
1 row in set (0.00 sec)

mysql> SELECT LOG10(100);
| LOG10(100) |
| 2 |
1 row in set (0.01 sec)

MySQL Tutorials

MySQL Tutorials on this website:

For more information on MySQL Database:

Exit mobile version