mysql中如何去除小数点后面多余的0
select cast(2.12000 as decimal(9,2))结果
2.12
select cast(2.10000 as decimal(9,2)) 结果
2.1
select cast(2.00000 as decimal(9,2)) 结果
2
2.12
select cast(2.10000 as decimal(9,2)) 结果
2.1
select cast(2.00000 as decimal(9,2)) 结果
2
相关推荐
RealJianyuan 2020-06-14
秒懂数学 2014-01-26
xiaoge00 2019-10-19
dreamjava 2014-07-08
ykmail 2019-08-19
joyleeLyhua 2009-09-02
我壮壮壮 2019-07-01
一只懒虫 2016-08-18
xiahanss 2011-11-30
zluxingzhe 2019-06-27
xiaocaibai 2014-07-08
秒懂数学 2014-01-26
libowen0 2019-06-26
pfpfpfpfpf 2010-04-21
伊文硕Oracle 2013-03-21