In MariaDB, UUID() is a built-in function that returns a Universal Unique Identifier (UUID).
The UUID is generated according to “DCE 1.1: Remote Procedure Call” (Appendix A) CAE (Common Applications Environment) Specifications published by The Open Group in October 1997 (Document Number C706).
Continue readingIn MariaDB, ADD_MONTHS() is a built-in date and time function that adds a given number of months to a date, and returns the result.
The date can be a date, datetime, or timestamp value.
This function was introduced in MariaDB 10.6.1 to enhance Oracle compatibility. There are at least 6 other ways to add months to a date in MariaDB.
Continue readingIn 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.
Continue readingIn 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 readingIn MariaDB, LOG10() is a built-in function that returns the base-10 logarithm of its argument.
In MariaDB, LOG2() is a built-in function that returns the base-2 logarithm of its argument.
In MariaDB, TRUNCATE() is a built-in numeric function that returns a given number, truncated to a given number of decimal places.
In MariaDB, ABS() is a built-in numeric function that returns the absolute (non-negative) value of its argument.
In MariaDB, ROUND() is a built-in numeric function that rounds its argument to a given number of decimal places.
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 reading