Numeric
https://dev.mysql.com/doc/refman/5.7/en/numeric-functions.html
Name | Description |
Return the absolute value | |
Return the arc cosine | |
Return the arc sine | |
Return the arc tangent | |
Return the arc tangent of the two arguments | |
Return the smallest integer value not less than the argument | |
Return the smallest integer value not less than the argument | |
Convert numbers between different number bases | |
Return the cosine | |
Return the cotangent | |
Compute a cyclic redundancy check value | |
Convert radians to degrees | |
Integer division | |
Division operator | |
Raise to the power of | |
Return the largest integer value not greater than the argument | |
Return the natural logarithm of the argument | |
Return the natural logarithm of the first argument | |
Return the base-10 logarithm of the argument | |
Return the base-2 logarithm of the argument | |
Minus operator | |
Return the remainder | |
Modulo operator | |
Return the value of pi | |
Addition operator | |
Return the argument raised to the specified power | |
Return the argument raised to the specified power | |
Return argument converted to radians | |
Return a random floating-point value | |
Round the argument | |
Return the sign of the argument | |
Return the sine of the argument | |
Return the square root of the argument | |
Return the tangent of the argument | |
Multiplication operator | |
Truncate to specified number of decimal places | |
Change the sign of the argument |
Rounds the argumentX
_toD
decimal places. The rounding algorithm depends on the data type ofX
.D
defaults to 0 if not specified.D
can be negative to causeD
digits left of the decimal point of the valueX
_to become zero.
MOD(N,M)
N % M
N MOD M
Modulo operation. Returns the remainder ofN
divided byM
.
Last updated