MySQL常用函数学习之数学函数
round 四舍五入
SELECT ROUND(1.5) AS 四舍五入;
[
SELECT ROUND(2.21612312,2) AS 四舍五入取小数点后两位;
ceil 向上取整(返回大于等于该参数的最小整数)
SELECT CEIL(-1.6) AS 向上取整;
floor 向下取整(返回小于等于该参数的最大整数)
SELECT FLOOR(-5.4) AS 向下取整;
truncate 截断
SELECT TRUNCATE(1.12312312,2) AS 直接截断不进行四舍五入;
mod 取余(mod(-10,-3)=-10-(-10/-3*-3)=-1)
SELECT MOD(-10,-3) AS 取余;