将数字格式化为小数点后两位时TRUNCATE,您有两个选项和ROUND。您正在寻找TRUNCATE功能。
例子:
不取整:
TRUNCATE(0.166, 2)
-- will be evaluated to 0.16
TRUNCATE(0.164, 2)
-- will be evaluated to 0.16
docs:http : //www.w3resource.com/mysql/mathematical-functions/mysql-truncate-function.php
四舍五入:
ROUND(0.166, 2)
-- will be evaluated to 0.17
ROUND(0.164, 2)
-- will be evaluated to 0.16
docs:http : //www.w3resource.com/mysql/mathematical-functions/mysql-round-function.php