MYSQL Math functions

MySQL provides a wide range of functions which serves a wide range of arithmetical purposes. The following table indicates each of the functions with a brief description:

FunctionsDescription
ABS()The ABS() function returns the absolute value of the specified number.
ACOS()The ACOS() function is used to get the arc cosine of the given number.
SIGN()The SIGN() function is used to get a sign of the specified number.
SIN()The SIN() function is used to get the sine value of the given number.
SQRT()The SQRT() function is used to get the square root of the given number.
SUM()This function is used to sum the values of given expressions.
TAN()The TAN() function is used to get the tangent of the given number
TRUNCATE()The TRUNCATE() function is used to get the given number truncated up to given certain decimal places.
ASIN()The ASIN() function is used to get the arc sine of the given number.
ATAN2()The ATAN2 function is used to get the arc tangent of the specified numbers n and m.
ATAN()The ATAN() function is used to get the arc tangent of the specified number.
AVG()The AVG() function is used to get the average value from the given expression.
CEIL()The CEIL() function returns the smallest value which is greater than or equal to the specified number.
CEILING()The CEILING() function returns the smallest value which is greater than or equal to the given number.
COS()The COS() function is used to get the cosine of the given number.
COT()The COT() function is used to get the cotangent of the given number.
COUNT()The COUNT() function is used to get the total count for the specified column of the table.
DEGREES()DEGREES() function is used to convert the given radian number into a degree.
DIV()The DIV() function is used to find the integer division by dividing the number n by the number m.
EXP()The EXP() function is used to find e raised to the power of number i.e. enumber.
FLOOR()The FLOOR() function is used to find the greatest integer which is equal to or less than the specified number.
GREATEST()The GREATEST() function is used to get the largest number from the list.
LEAST()The LEAST() function is used to get the smallest number from the list.
LN()The LN() function is used to get the natural logarithm for the specified number.
LOG10()The LOG10() function is used to get the base-10 logarithm for the specified number.
LOG()The LOG() function is used to return either the natural logarithm of the given number if it has one parameter or specified base logarithm number if it has two parameters.
LOG2()The LOG2() function is used to get the base-2 logarithm for the specified number.
MAX()The MAX() function is used to get the maximum number of the given column name.
MIN()The MIN() function is used to get the minimum number of the given column name.
MOD()The MOD() function is used to get the remainder for the specified values.
PI()The PI() function is used to get the value of pi upto 6 decimal places.
POWER()The POWER() function is used to get the power for the specified values.
POW()The POW function is used to get the power for the specified values.
RADIANS()The RADIANS() function is used to convert the given degrees to radians.
RAND()The RAND() function is used to generate the random number.
ROUND()The ROUND() function is used to round off the specified number.

Example 1

Output:

mysql> SELECT PI();
+----------+
| PI()     |
+----------+
| 3.141593 |
+----------+
1 row in set (0.00 sec)

Example 2

Output:

mysql> SELECT POW(3, 2);
+-----------+
| POW(3, 2) |
+-----------+
|         9 |
+-----------+
1 row in set (0.00 sec)

Example 3

Output:

mysql> SELECT 4 % 3;
+-------+
| 4 % 3 |
+-------+
|     1 |
+-------+
1 row in set (0.00 sec)
Next TopicMySQL Math




Latest Courses