select 0+CAST(result.count as char)
from (select round(10.000001, 2) as count) as result
MySQL将查询结果有小数位就保留,如果小数位是0,转为整数
最新推荐文章于 2024-04-25 12:02:52 发布
select 0+CAST(result.count as char)
from (select round(10.000001, 2) as count) as result