MySQL COT Function

MySQL COT function is one of the Numeric Functions which calculates the trigonometry cotangent of the specified expression. The mathematical formula for this is: COT(x) = 1 / TAN(x).

The basic syntax of the MySQL COT function is as shown below:

SELECT COT (Numeric_Expression)
FROM Source

To demonstrate this Numeric method, we are going to use the below shown data

Numeric Table 1

MySQL COT Function Example

The COT returns the trigonometric cotangent value of any numeric value, and the following query shows multiple ways to use this function.

-- Cotangent of Negative Value
SELECT COT(-120.75) AS `Cotangent Value`;

-- Cotangent of Positive Value
SELECT COT(127.96) AS `Cotangent Value`;

-- Cotangent of Numeric Expression
SELECT COT(1.75 + 2.25 - 4.00) AS `Cotangent Value`;

-- Cotangent of string value
SELECT COT('0.74') AS `Cotangent Value`;

-- Cotangent of String
SELECT COT('MySQL') AS `Cotangent Value`;

-- Cotangent of NULL Value
SELECT COT(NULL) AS `Cotangent Value`;

From the screenshot below, you can see that we used the COT function to find the Cotangent values of different values. Here, we assigned a new name to the MySQL result as ‘Cotangent Value’ using the ALIAS Column.

COT Example 2

This Numeric method also allows you to find the cotangent values for the data in a table column. In this example, we are going to find the cotangent for all the records present in the Tax Amount column and Service Grade column.

--  Cotangent Example

SELECT Product, Color,
		StandardCost, Sales, TaxAmt,
        COT(TaxAmt) AS `Tax Cotangent Value`,
        COT(ServiceGrade) AS `Grade Cotangent Value`
FROM `numeric functions`;
MySQL COT Function Example 3

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.