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.
numeric functions
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.
How POW() Works in MariaDB
In MariaDB, POW() is a built-in function that returns the value of its first argument raised to the power of its second argument.
How CONV() Works in MariaDB
In MariaDB, CONV() is a built-in numeric function that converts numbers between different number bases. For example, you can use it to convert a number from base 10 to base 16.
It returns a string representation of the converted number.
How MOD() Works in MariaDB
In MariaDB, MOD() is a built-in function that returns the modulo operation. It returns the remainder of its first argument divided by its second argument.
How LEAST() Works in MariaDB
In MariaDB, LEAST() is a built-in function that returns the least (i.e. smallest/minimum-valued) argument from its list of arguments.
To get the greatest value, use GREATEST().
How COT() Works in MariaDB
In MariaDB, COT() is a built-in numeric function that returns the cotangent of its argument.
In trigonometry, in a right triangle, the cotangent of an angle is the length of the adjacent side divided by the length of the opposite side.
How COS() Works in MariaDB
In MariaDB, COS() is a built-in numeric function that returns the cosine of its argument, where the argument is provided in radians.