mysql update convert cast 时报 Truncated incorrect INTEGER value 的解决方法

解决方法，在update之后加上IGNORE就好了

update IGNORE customer set capital_number = CONVERT(capital,SIGNED) where capital like '%测试数据%' and capital_number is null