+-*/
CEIL() 进一取整
SELECT CEIL(3.01);
4
DIV 整数除法
SELECT 3/4;
0.75
SELECT 3 DIV 4;
0
FLOOR()舍一取证
SELECT FLOOR(3.01);
3
MOD 取余数(取摩)
SELECT 5%3;
2
SELECT 5 MOD 3;
2
SELECT 5.3 MOD 3;
2.3
POWER()幂运算
SELECT POWER(3,3);
27
ROUND()四舍五入
SELECT ROUND(3.652,2);
3.65
SELECT ROUND(3.652,1);
3.7
TRUNCATE()数字截取
SELECT TRUNCATE(125.89,2);
125.89
SELECT TRUNCATE(125.89,1);
125.8
SELECT TRUNCATE(125.89,0);
125
SELECT TRUNCATE(125.89,-1);
120