Mathematical Functions :

ABS	ACOS	ASIN	ATAN	CEIL
COS	COT	DEGREES	EXP	FLOOR
FORMAT	LN	LOG	LOG(B,X)	LOG2
LOG10	MOD	PI	POWER	RADIANS
RAND	ROUND	SIGN	SIN	SQRT
TAN	TRUNCATE

    Now lets see Mysql Math functions with examples.

ABS(X) :

    This function returns the Absolute value of the given value.

mysql> select abs(5);
 -->  5

mysql> select abs(-25);
 -->  25

mysql> select acos(0);
 -->  1.5707963267949

mysql> select acos(1);
 -->  0

mysql> select asin(1);
 -->  1.5707963267949

mysql> select asin(0);
 -->  0

mysql> select atan(1);
 -->  0.78539816339745

mysql> select atan(2);
 -->  1.1071487177941

mysql> select ceil(1.14);
 -->  2

mysql> select ceiling(-1.14);
 -->  -1

mysql> select cos(pi());
 -->  -1

mysql> select cos(0);
 -->  1

mysql> select cot(1);
 -->  0.64209261593433

mysql> select cot(45);
 -->  0.61736962378356