+-*/
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 CEIL(3.01);
4
SELECT 3/4;
0.75
SELECT 3 DIV 4;
0
SELECT FLOOR(3.01);
3
SELECT 5%3;
2