SELECT ASIN('foo'); : ASIN « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. ASIN
mysql>
mysql>
mysql> SELECT ASIN('foo');
+-------------+
| ASIN('foo') |
+-------------+
|           0 |
+-------------+
1 row in set, 1 warning (0.00 sec)

mysql>
mysql> SHOW WARNINGS;
+---------+------+-----------------------------------------+
| Level   | Code | Message                                 |
+---------+------+-----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: 'foo' |
+---------+------+-----------------------------------------+
1 row in set (0.00 sec)

mysql>








21.5.ASIN
21.5.1.ASIN(X) returns the arc sine of X. Returns NULL if X is not in the range -1 to 1.
21.5.2.SELECT ASIN('foo');