mysql中如何去除小数点后面多余的0_MySQL
程序员文章站
2022-03-23 23:37:09
...
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
2.12
select cast(2.10000 as decimal(9,2)) 结果
2.1
select cast(2.00000 as decimal(9,2)) 结果
2bitsCN.com