In MariaDB, SIGN() is a built-in function that returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive.
numeric functions
How SIN() Works in MariaDB
In MariaDB, SIN() is a built-in numeric function that returns the sine of its argument, where its argument is provided in radians.
How PI() Works in MariaDB
In MariaDB, PI() is a built-in function that returns the value of the number π (pi).
The number π is a mathematical constant. It is defined as the ratio of a circle’s circumference to its diameter, and it also has various equivalent definitions. It is approximately equal to 3.141593, although its decimal representation never ends.
How CRC32 Works in MariaDB
In MariaDB, CRC32() is a built-in numeric function that computes a cyclic redundancy check value and returns a 32-bit unsigned value.
CRC32 is a popular checksum algorithm used to detect data corruption.
How LOG10() Works in MariaDB
In MariaDB, LOG10() is a built-in function that returns the base-10 logarithm of its argument.
How LOG2() Works in MariaDB
In MariaDB, LOG2() is a built-in function that returns the base-2 logarithm of its argument.
How TRUNCATE() Works in MariaDB
In MariaDB, TRUNCATE() is a built-in numeric function that returns a given number, truncated to a given number of decimal places.
How ABS() Works in MariaDB
In MariaDB, ABS() is a built-in numeric function that returns the absolute (non-negative) value of its argument.
How ROUND() Works in MariaDB
In MariaDB, ROUND() is a built-in numeric function that rounds its argument to a given number of decimal places.
How ASIN() Works in MariaDB
In MariaDB, ASIN() is a built-in numeric function that returns the arcsine (inverse sine) of its argument.
In other words, it returns the value whose sine is the argument.