mysql 在update 语句中使用cast 时出现错误1292

Question

以下语句返回“错误代码: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)

Answer 1

试试这个

update IGNORE new2006 set new2006.emp=cast(emp as unsigned) where IsNum(emp)=0;