SIN()

Description

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

Syntax

  1. > SIN(number)

Arguments

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