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().
Tag: what is
How GREATEST() Works in MariaDB
In MariaDB, GREATEST() is a built-in function that returns the greatest (i.e. largest/maximum-valued) argument from its list of arguments.
To return the minimum-valued argument, use LEAST().
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.
Continue readingHow 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.
How LOG() Works in MariaDB
In MariaDB, LOG() is a built-in function that returns the natural logarithm of its argument to a given base.
It can be called with one or two arguments:
- When called with one argument, returns the natural logarithm of the argument.
- When called with two arguments, returns the logarithm of the second argument to the base specified in the first argument.
When called with a single argument, LOG() is the inverse of EXP(), and it’s the same as using LN().
How LN() Works in MariaDB
In MariaDB, LN() is a built-in function that returns the natural logarithm of its argument. In other words, it returns the base-e logarithm of its argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
LN() is the inverse of EXP(), and it’s the same as using LOG() with the single argument syntax.
How EXP() Works in MariaDB
In MariaDB, EXP() is a built-in function that returns the value of e (the base of natural logarithms) raised to the power of the argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
The inverse of EXP() is the LN() function or LOG() function (when using the single argument syntax).
How RADIANS() Works in MariaDB
In MariaDB, RADIANS() is a built-in function that returns its argument converted from degrees to radians.
The RADIANS() function is the converse of the DEGREES() function.
How DEGREES() Works in MariaDB
In MariaDB, DEGREES() is a built-in function that returns its argument converted from radians to degrees.
The DEGREES() function is the converse of the RADIANS() function.
How FLOOR() Works in MariaDB
In MariaDB, FLOOR() is a built-in numeric function that returns the largest integer value not greater than its argument.