MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References
MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

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:

Datax
Data 1-10
Data 2-5
Data 30
Data 45
Data 510

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:

DataxSIN_Value
Data 1-100.5440211108893698
Data 2-50.9589242746631385
Data 300
Data 45-0.9589242746631385
Data 510-0.5440211108893698

❮ MySQL Functions
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.