In MySQL, the SQRT() function returns the square root of a nonnegative number.
You provide the number as an argument when calling the function.
Tag: mathematical functions
MySQL SIN() Function – Return the Sine of a Number in MySQL
In MySQL, the SIN() function returns the sine of a given value, where the value is given in radians.
The sine is a trigonometric function of an angle. The sine of an acute angle is defined in the context of a right triangle: for the specified angle, it is the ratio of the length of the side that is opposite that angle to the length of the longest side of the triangle (the hypotenuse).
MySQL SIGN() Function – Find Out Whether a Number is Positive or Negative in MySQL
In MySQL, the SIGN() function returns the sign of a number. That is, it indicates whether or not the value is a positive number, a negative number, or zero.
You provide the value as an argument when calling the function.
The function returns the following result, depending on whether the argument is positive, negative, or zero.
- 1 if the number is positive
- -1 if the number is negative
- 0 if the number is zero
MySQL POW() Function – Raise a Value to the Power of Another Value
In MySQL, the POW() function raises a number to the power of another number.
You provide the two values as arguments when calling the function.
MySQL MOD() Function – Perform a Modulo Operation in MySQL
In MySQL, the MOD() function performs a modulo operation. It returns the remainder of a number divided by another number.
You provide the two values as arguments when calling the function.
MySQL LOG10() Function – Return the Base-10 Logarithm of a Value
In MySQL, the LOG10() function returns the base-10 logarithm of a specified value.
You provide the specified value as an argument when calling the function.
MySQL LOG2() Function – Return the Base-2 Logarithm of a Value
In MySQL, the LOG2() function returns the base-2 logarithm of a specified value.
You provide the specified value as an argument when calling the function.
MySQL LOG() Function – Return the Natural Logarithm of a Value
In MySQL, the LOG() function returns the natural logarithm of a specified value.
You provide the specified value as an argument when calling the function.
MySQL LN() Function – Return the Natural Logarithm of a Number
MySQL EXP() Function – Return e Raised to the Power of x
In MySQL, the EXP() function returns e raised to the power of a specified value.
You provide the specified value as an argument when calling the function.
The number e is a mathematical constant that is the base of the natural logarithm: the unique number whose natural logarithm is equal to one. It is approximately equal to 2.71828.