MySQL COT() Function
The MySQL COT() function returns trigonometric cotangent of an angle (angle should be in radians). In special cases it returns the following:
- If x is 0, then NULL or an error (depending on the version of MySQL) is returned.
Syntax
COT(x)
Parameters
x |
Required. Specify the angle in radian. |
Return Value
Returns the trigonometric cotangent of an angle.
Example 1:
The example below shows the usage of COT() function.
mysql> SELECT COT(1); Result: 0.6420926159343306 mysql> SELECT COT(2); Result: -0.45765755436028577 mysql> SELECT COT(3); Result: -7.015252551434534 mysql> SELECT COT(-1); Result: -0.6420926159343306 mysql> SELECT COT(-2); Result: 0.45765755436028577 mysql> SELECT COT(-3); Result: 7.015252551434534 mysql> SELECT COT(PI()); Result: -8.165619676597685e15
Example 2:
Consider a database table called Sample with the following records:
Data | x |
---|---|
Data 1 | 0.5 |
Data 2 | 1 |
Data 3 | 5 |
Data 4 | 10 |
Data 5 | 50 |
The statement given below can be used to calculate the trigonometric cotangent value of column x.
SELECT *, COT(x) AS COT_Value FROM Sample;
This will produce the result as shown below:
Data | x | COT_Value |
---|---|---|
Data 1 | 0.5 | 1.830487721712452 |
Data 2 | 1 | 0.6420926159343306 |
Data 3 | 5 | -0.2958129155327455 |
Data 4 | 10 | 1.5423510453569202 |
Data 5 | 50 | -3.677814450850569 |
❮ MySQL Functions