复制mysql> select cast(‘125e342.83′ as signed) as clm1,数字 cast(‘foo seo 589′ as signed) as clm2,cast(‘3.35′ as signed) as clm3; +——+——+——+ | clm1 | clm2 | clm3 | +——+——+——+ | 125 | 0 | 3 | +——+——+——+ 1 row in set, 3 warnings (0.00 sec) mysql> 1.2.3.4.5.6.7.8. |
喜欢
讨厌