MySQL Trigonometry Functions
MySQL Trigonometry Functions
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/
