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.
Continue readingReplace a String with another String in SQL Server (T-SQL)
In SQL Server you can use the REPLACE() function to replace all occurrences of a string with another string.
The function accepts three arguments; the string that contains the string to be replaced, the string to be replaced, and the string to replace it.
Continue readingHow the Modulo Operator Works in MariaDB
In MariaDB, the modulo operator (%) returns the modulo operation. It returns the remainder of its first argument divided by its second argument.
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 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().