SIN()

Description

The SIN() function returns the sine of input number(given in radians).

Syntax

1. > SIN(number)

Arguments

Arguments Description
number Required. Any numeric data type supported now.

Examples

1. drop table if exists t1;
2. create table t1(a int,b float);
3. insert into t1 values(1,3.14159);
4. insert into t1 values(-1,1.57);

6. mysql> select sin(a),sin(b) from t1;
7. +---------------------+--------------------------+
8. | sin(a)              | sin(b)                   |
9. +---------------------+--------------------------+
10. |  0.8414709848078965 | 0.0000025351815901107472 |
11. | -0.8414709848078965 |       0.9999996829736023 |
12. +---------------------+--------------------------+
13. 2 rows in set (0.01 sec)