mysql 取整数或小数或精确位数
select cast(19.16558 as decimal(9,2))#精确到几位 select round(123.5); #四舍五入 select floor(123.5);#取整数部分 select ceil(123.5);#四舍五入
参考:
https://blog.csdn.net/qq_37107280/article/details/77542127
https://blog.csdn.net/weixin_29082969/article/details/84070492