In MariaDB, DIV performs integer division.
It discards from the division result any fractional part to the right of the decimal point.
what is
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.
How 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.
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 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.