MYSQL数学函数哪些事

round 四舍五入

SELECT ROUND(1.5) AS 结果

2

select round(1.45) AS 结果

1

#意思小数点后面保留两位

SELECT ROUND(0.3455,2) AS 结果

ciel 向上取整

#向上取整,返回>=该参数的最小整数**

SELECT CEIL(1.00) math

1

SELECT CEIL(0.23) math

结果是1

floor 向下取整

select floor(1.45) as 结果

1

truncate 截断

SELECT TRUNCATE(1.33,1) AS 结果

1.3

mod 取余

/*
mod(a,b) ： a-a/b*b

mod(-10,-3):-10- (-10)/(-3)*（-3）=-1
*/

select mod(10,3) as 结果

1