MySQL ASIN() Function

 The ASIN() function in MySQL is a mathematical function that returns the inverse sine (arc sine) of a number. It returns the value in radians, which is a value between -π/2 and π/2.

Syntax:

ASIN(number)

• number: A numeric value (must be between -1 and 1 inclusive), representing the sine of the angle.

Example:

To get the arc sine of 0.5:

SELECT ASIN(0.5);

This will return the inverse sine of 0.5 in radians.

Important Notes:

• The ASIN() function is used to compute the angle whose sine is the given number.
• The number passed must be in the range of -1 to 1 (inclusive). If you provide a value outside this range, MySQL will return NULL.

Converting Radians to Degrees:

If you want the result in degrees instead of radians, you can multiply the result by 180/π. For example:

SELECT DEGREES(ASIN(0.5));

This converts the result from radians to degrees, and the result will be 30.