Mysql常用函数-数学类

//绝对值
ABS (number2 )

//十进制转二进制
BIN (decimal_number )

//向上取整
CEILING (number2 )

//进制转换
CONV(number2,from_base,to_base)

//向下取整
FLOOR (number2 )

//保留小数位数
FORMAT (number,decimal_places )

//转十六进制
HEX (DecimalNumber )

//求最小值
LEAST (number , number2 [,..])

//求余
MOD (numerator ,denominator )

//求指数
POWER (number ,power )

//随机数
RAND([seed])

//四舍五入,decimals为小数位数
ROUND (number [,decimals ])

//返回符号,正负或0
SIGN (number2 )

//开平方
SQRT(number2)