SQL Tutorial SQL Advanced SQL Database SQL References

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:

Datax
Data 10.5
Data 21
Data 35
Data 410
Data 550

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:

DataxCOT_Value
Data 10.51.830487721712452
Data 210.6420926159343306
Data 35-0.2958129155327455
Data 4101.5423510453569202
Data 550-3.677814450850569

❮ MySQL Functions