# Overview

In this tutorial, we will learn about MySQL trigonometry functions with examples. MySQL supports many in built functions.

## Geometry functions

Let’s understand some basic geometry functions before trigonometry functions.

 MySQL Geometry Function Description PI() This function returns the value of pi. DEGREES(X) This function returns the value of X, converted from radians to degrees. radians -> degrees RADIANS(X) This function returns the value of X, converted from degrees to radians. degrees -> radians

mysql> SELECT PI();
+———-+
| PI() |
+———-+
| 3.141593 |
+———-+

mysql> SELECT DEGREES(PI());
+—————+
| DEGREES(PI()) |
+—————+
| 180 |
+—————+ ## MySQL Trigonometry Functions

Some of the functions are listed below:

 MySQL Trigonometry Function Description COS(X) The function returns the cosine of X, where X is given in radians. SIN(X) The function returns the sine of X, where X is given in radians. TAN(X) The function returns the tangent of X, where X is given in radians. COT(X) The function returns the cotangent of X, where X is given in radians. ACOS(X) This function returns the arc cosine of X, that is, the value whose cosine is X. It returns NULL if X is not in the range -1 to 1. ASIN(X) The function returns the arc sine of X, that is, the value whose sine is X. It returns NULL if X is not in the range -1 to 1. ATAN(X) The function returns the arc tangent of X, that is, the value whose tangent is X. ATAN2(X,Y) The function returns the arc tangent of the two variables X and Y. The signs of both arguments are used to determine the quadrant of the result.

## Examples

mysql> SELECT COS(PI()/4);
+——————–+
| COS(PI()/4) |
+——————–+
| 0.7071067811865476 |
+——————–+

mysql> SELECT TAN(PI()/4);
+——————–+
| TAN(PI()/4) |
+——————–+
| 0.9999999999999999 |
+——————–+ ## MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/