Overview
In this tutorial, we will learn about MySQL mathematical functions with examples. MySQL supports many in built functions. Mathematical functions are type of function that are mostly used for mathematical calculations.
MySQL Mathematical Functions
Some MySQL mathematical function are as follows:
| Numeric Function |
Description |
| EXP(X)
|
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. ) |
Examples
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:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: