% , 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将弧度转换为度 |
DIV | 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() | Return the base-10 logarithm of the argument返回参数的以10为底的对数 |
LOG2() | Return the base-2 logarithm of the argument返回参数的以2为底的对数 |
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截断到指定的小数位数 |