以下语句返回“错误代码:1292。截断不正确的整数值:'95.00'1.132 秒”
update new2006 set new2006.emp=cast(emp as unsigned) where IsNum(emp)=0;
但如果我使用下面的语句,我可以成功得到结果 95。
select cast(emp as unsigned) from new2006 where IsNum(emp)=0;
PS:emp的数据类型是varchar(7)。
Try this
update IGNORE new2006 set new2006.emp=cast(emp as unsigned) where IsNum(emp)=0;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)