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

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:

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: