MySQL: Numeric Functions List

Here is the list of numeric functions in MySQL.

ABS: Gives out the absolute value of a number.
ACOS: Gives the arc cosine of a number.
ASIN: Gives the arc sine of a number.
ATAN: Gives out the arctangent of one or more numbers.
ATAN2: Gives out arc tangent of multiple numbers
AVG: This function returns the average value.
CEIL: Gives out the smallest integer, >= to a number.
CEILING: Gives out the smallest integer, >= to a number.
COS: Gives the cosine of a number.
COT: Gives the cotangent of a number.
COUNT: Gives out the number of records returned by a select query.
DEGREES: This function converts a value in radians to degrees.
DIV: This function is used for integer division.
EXP: Gives out e raised to the power of a specified number.
FLOOR: Gives the enormous integer value that is <= to a number.
GREATEST: This function returns the greatest value of the list of arguments.
LEAST: This function gives out the smallest value of the list of arguments.
LN: This one returns the natural logarithm of a number.
LOG: This function returns the natural logarithm of a number or the logarithm of a number to a specified base.
LOG10: This function returns the natural logarithm of a number to base of 10.
LOG2: Function returns the natural logarithm of a number to base 2.
MAX: This function returns the max value in a set of values.
MIN: This function returns the min value in a set of values.
MOD: Function returns the remainder of a number divided by another one.
PI: Gives out the value of PI.
POW: This function returns the value of a number raised to power of another number.
POWER: This function returns the value of a number raised to the power of another number.
RADIANS: This function converts a degree value into radians.
RAND: Gives out a random number.
ROUND: This one Rounds a number to a specified number of decimal places.
SIGN: Function returns the character of a number.
SIN: This function returns the sine of number.
SQRT: Function returns the square root of a number.
SUM: This function calculates the sum of set of values.
TAN: Function returns the tangent of a number.
TRUNCATE: This function truncates a number to the specified number of decimal places.