col是int(4)
SELECT CASE WHEN col>=100 THEN col/100 ELSE col END FROM 表
结果是
1.0000
2.0000
13.0000
能让结果还是int吗
就是这样的
1
2
13
SELECT CASE WHEN col>=100 THEN col/100 ELSE col END FROM 表
结果是
1.0000
2.0000
13.0000
能让结果还是int吗
就是这样的
1
2
13
+---------------------+
| cast(1/1 as SIGNED) |
+---------------------+
| 1 |
+---------------------+
1 row in set (0.04 sec)