MySQL 8.4 Release Notes
表 14.8 数值函数和运算符Table 14.8 Numeric Functions and Operators
| 名称Name | 说明Description |
|---|---|
%, MOD |
取模运算符Modulo operator |
* |
乘法运算符Multiplication operator |
+ |
加法运算符Addition operator |
- |
减法运算符Minus operator |
- |
改变参数的符号Change the sign of the argument |
/ |
除法运算符Division operator |
ABS() |
返回绝对值Return the absolute value |
ACOS() |
返回反余弦Return the arc cosine |
ASIN() |
返回反正弦Return the arc sine |
ATAN() |
返回反正切Return the arc tangent |
ATAN2(), ATAN() |
返回两个参数的反正切Return the arc tangent of the two arguments |
CEIL() |
返回不小于参数的最小整数值Return the smallest integer value not less than the argument |
CEILING() |
返回不小于参数的最小整数值Return the smallest integer value not less than the argument |
CONV() |
在不同的数字进制之间转换数字Convert numbers between different number bases |
COS() |
返回余弦值Return the cosine |
COT() |
返回余切Return the cotangent |
CRC32() |
计算循环冗余校验值Compute a cyclic redundancy check value |
DEGREES() |
将弧度转换为度Convert radians to degrees |
DIVDIV |
整数除法Integer division |
EXP() |
乘方Raise to the power of |
FLOOR() |
返回不大于参数的最大整数值Return the largest integer value not greater than the argument |
LN() |
返回参数的自然对数Return the natural logarithm of the argument |
LOG() |
返回第一个参数的自然对数Return the natural logarithm of the first argument |
LOG10() |
返回参数的以 10 为底的对数Return the base-10 logarithm of the argument |
LOG2() |
返回参数的以 2 为底的对数Return the base-2 logarithm of the argument |
MOD() |
返回余数Return the remainder |
PI() |
返回圆周率的值Return the value of pi |
POW() |
返回指定次方的参数Return the argument raised to the specified power |
POWER() |
返回指定次方的参数Return the argument raised to the specified power |
RADIANS() |
返回转换为弧度的参数Return argument converted to radians |
RAND() |
返回一个随机浮点值Return a random floating-point value |
ROUND() |
围绕论点Round the argument |
SIGN() |
返回参数的符号Return the sign of the argument |
SIN() |
返回参数的正弦值Return the sine of the argument |
SQRT() |
返回参数的平方根Return the square root of the argument |
TAN() |
返回参数的正切值Return the tangent of the argument |
TRUNCATE() |
截断到指定的小数位数Truncate to specified number of decimal places |