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.
Continue readingTag: numeric functions
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.
Continue readingHow RAND() Works in MariaDB
In MariaDB, RAND() is a built-in function that returns a random DOUBLE precision floating point value v in the range 0 <= v < 1.0.
How ACOS() Works in MariaDB
In MariaDB, ACOS() is a built-in numeric function that returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
Continue readingMariaDB POWER() Explained
In MariaDB, POWER() is a synonym to POW(), which is built-in function that returns the value of its first argument raised to the power of its second argument.