mysql中如何去除小数点后面多余的0_MySQL
来源：动视网
责编：小采
时间：2020-11-09 19:08:03
mysql中如何去除小数点后面多余的0_MySQL
mysql中如何去除小数点后面多余的0_MySQL:bitsCN.com 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)) 结果 2bitsCN.com
导读mysql中如何去除小数点后面多余的0_MySQL:bitsCN.com 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)) 结果 2bitsCN.com
bitsCN.com
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)) 结果
2bitsCN.com
mysql中如何去除小数点后面多余的0_MySQL
mysql中如何去除小数点后面多余的0_MySQL:bitsCN.com 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)) 结果 2bitsCN.com
