求大虾指点，关于小数点后的有效数字
我数据库字段类型是double，保留位数是3，然后里面数值为0.000,0.040,0.045,如果我要通过sql语句来读取，去除末尾的0，让数值0.000时为0，0.040的时候为0.04

[解决办法]
try:
SELECT IF(f1=0.000,0,CAST(f1 AS DECIMAL(12,2))) FROM tt
[解决办法]

SQL code

mysql> select * from gn_Grade;+-------+| x     |+-------+| 0.000 || 0.040 || 0.045 |+-------+3 rows in set (0.00 sec)mysql> select TRIM(TRAILING '0' FROM x)+0 from gn_Grade;+-----------------------------+| TRIM(TRAILING '0' FROM x)+0 |+-----------------------------+|                           0 ||                        0.04 ||                       0.045 |+-----------------------------+3 rows in set (0.00 sec)mysql>