How to get ARC Sine(ASIN) value in MySQL8?

by · Published · Updated

With MySQL, we can do complex calculations very easily with the help of inbuilt mathematical functions. ASIN(number) helps in getting the angle, in radians, whose sine is provided as input number. Now let’s start with these.

ASIN(N) is a mathematical function. It returns the arc sine of a number, that is, the value whose sine is number. It returns NULL, if number is not in the range -1 to 1.

It returns Warning, if any string argument is passed.

MySQL ASIN() : Syntax

ASIN (number)

MySQL ASIN() : Parameter

Name, Required /Optional, Type, Description
number, Required, Double, It represents a valid number between -1.00 and 1.00.

MySQL ASIN() : Output

Return, Description
NULL, if the argument is NULL.
Double, It returns the arcsine of the input number.

MySQL ASIN()  Available from : MySQL 4.0

ASIN() Example 1 : Very Basic example

Below is a very easy example. See the value when we pass the input as 0.

mysql> SELECT ASIN(0);
+---------+
| ASIN(0) |
+---------+
| 0 |
+---------+
1 row in set (0.21 sec)

See the value when we pass the input as 1.

mysql> SELECT ASIN(1);
+--------------------+
| ASIN(1) |
+--------------------+
| 1.5707963267948966 |
+--------------------+
1 row in set (0.06 sec)

See the value when we pass the input as -1.

mysql> SELECT ASIN(-1);
+---------------------+
| ASIN(-1) |
+---------------------+
| -1.5707963267948966 |
+---------------------+
1 row in set (0.01 sec)

ASIN() Example 2 :

Below are some more examples.

mysql> SELECT ASIN(.13256);
+--------------------+
| ASIN(.13256) |
+--------------------+
| 0.1329513298423883 |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT ASIN(-.13256);
+---------------------+
| ASIN(-.13256) |
+---------------------+
| -0.1329513298423883 |
+---------------------+
1 row in set (0.00 sec)

ASIN() Example 3 : It will return Warning if any string argument is passed.

See the below example :

mysql> SELECT ASIN('TEST');
+--------------+
| ASIN('TEST') |
+--------------+
| 0 |
+--------------+
1 row in set, 1 warning (0.00 sec)

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

You can see the warning message with the help of the ‘SHOW WARNINGS’ command. Please refer above code for the same.

ASIN() Example 4 : NULL arguments

If the argument is NULL, it will return NULL. See the below example :

mysql> SELECT ASIN(NULL);
+------------+
| ASIN(NULL) |
+------------+
| NULL |
+------------+
1 row in set (0.05 sec)

If the input value is larger than the range of the input, then it also returns a NULL value. See the below example.

mysql> SELECT ASIN(2.5698);
+--------------+
| ASIN(2.5698) |
+--------------+
| NULL |
+--------------+
1 row in set (0.06 sec)

mysql> SELECT ASIN(-72.5698);
+----------------+
| ASIN(-72.5698) |
+----------------+
| NULL |
+----------------+
1 row in set (0.00 sec)

ASIN() Example 5 : Using expressions

Here are some more examples to use the expression with the ASIN() function :

mysql> SELECT ASIN(.5);
+--------------------+
| ASIN(.5) |
+--------------------+
| 0.5235987755982989 |
+--------------------+
1 row in set (0.00 sec)

Now, we will get the same value if we pass the .5 as (.2+.3). See the below screen

mysql> SELECT ASIN(.2+.3);
+--------------------+
| ASIN(.2+.3) |
+--------------------+
| 0.5235987755982989 |
+--------------------+
1 row in set (0.00 sec)

Similarly for expression (-.2+.3) = -.1. You can see in the below screen that both inputs yield the same results.

mysql> SELECT ASIN(-.2+.3);
+--------------------+
| ASIN(-.2+.3) |
+--------------------+
| 0.1001674211615598 |
+--------------------+
1 row in set (0.00 sec)
mysql> SELECT ASIN(-.1);
+---------------------+
| ASIN(-.1) |
+---------------------+
| -0.1001674211615598 |
+---------------------+
1 row in set (0.00 sec)

MySQL Related articles : LOCATE(), HEX(), CONCAT(), CONCAT_WS() , LOWER(), LTRIM(), INSTR(), POSITION(), MySQL STRING FUNCTIONS.

PHP Related articles : SUBSTR_COMPARE(), STRNCMP(), STRNCASECMP(), STRNATCASECMP(), PHP STRING FUNCTIONS().

You may also like...