MYSQL向上取整、向下取整和四舍五入

MYSQL向上取整、向下取整和四舍五入

1.MYSQL向上取整
SELECT CEIL(1.2)

2.MYSQL向下取整
SELECT FLOOR(1.2)

3.MYSQL四舍五入
SELECT ROUND(1.355, 2)