MySQL SIN() Function
The MySQL SIN() function returns trigonometric sine of an angle (angle should be in radians).
Syntax
SIN(x)
Parameters
x |
Required. Specify the angle in radian. |
Return Value
Returns the trigonometric sine of an angle.
Example 1:
The example below shows the usage of SIN() function.
mysql> SELECT SIN(0); Result: 0 mysql> SELECT SIN(1); Result: 0.8414709848078965 mysql> SELECT SIN(-1); Result: -0.8414709848078965 mysql> SELECT SIN(2); Result: 0.9092974268256817 mysql> SELECT SIN(-2); Result: -0.9092974268256817 mysql> SELECT SIN(PI()); Result: 1.2246467991473532e-16
Example 2:
Consider a database table called Sample with the following records:
Data | x |
---|---|
Data 1 | -10 |
Data 2 | -5 |
Data 3 | 0 |
Data 4 | 5 |
Data 5 | 10 |
The statement given below can be used to calculate the trigonometric sine value of column x.
SELECT *, SIN(x) AS SIN_Value FROM Sample;
This will produce the result as shown below:
Data | x | SIN_Value |
---|---|---|
Data 1 | -10 | 0.5440211108893698 |
Data 2 | -5 | 0.9589242746631385 |
Data 3 | 0 | 0 |
Data 4 | 5 | -0.9589242746631385 |
Data 5 | 10 | -0.5440211108893698 |
❮ MySQL Functions