Functions dealing with numerals, including ABS, CEIL, DIV, EXP, PI, SIN, etc.
| Title | Description |
|---|---|
| Addition Operator (+) | Addition. |
| Subtraction Operator (-) | Subtraction and unary minus. |
| Division Operator (/) | Division. |
| Multiplication Operator (*) | Multiplication. |
| Modulo Operator (%) | Modulo operator. Returns the remainder of N divided by M. |
| DIV | Integer division. |
| ABS | Returns an absolute value. |
| ACOS | Returns an arc cosine. |
| ASIN | Returns the arc sine. |
| ATAN | Returns the arc tangent. |
| ATAN2 | Returns the arc tangent of two variables. |
| CEIL | Synonym for CEILING(). |
| CEILING | Returns the smallest integer not less than X. |
| CONV | Converts numbers between different number bases. |
| COS | Returns the cosine. |
| COT | Returns the cotangent. |
| CRC32 | Computes a cyclic redundancy check value. |
| DEGREES | Converts from radians to degrees. |
| EXP | e raised to the power of the argument. |
| FLOOR | Largest integer value not greater than the argument. |
| GREATEST | Returns the largest argument. |
| LEAST | Returns the smallest argument. |
| LN | Returns natural logarithm. |
| LOG | Returns the natural logarithm. |
| LOG10 | Returns the base-10 logarithm. |
| LOG2 | Returns the base-2 logarithm. |
| MOD | Modulo operation. Remainder of N divided by M. |
| OCT | Returns octal value. |
| PI | Returns the value of π (pi). |
| POW | Returns X raised to the power of Y. |
| POWER | Synonym for POW(). |
| RADIANS | Converts from degrees to radians. |
| RAND | Random floating-point value. |
| ROUND | Rounds a number. |
| SIGN | Returns 1, 0 or -1. |
| SIN | Returns the sine. |
| SQRT | Square root. |
| TAN | Returns the tangent. |
| TRUNCATE | The TRUNCATE function truncates a number to a specified number of decimal places. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/numeric-functions/