解决方法,在update之后加上IGNORE就好了
update IGNORE customer set capital_number = CONVERT(capital,SIGNED) where capital like '%测试数据%' and capital_number is null
解决方法,在update之后加上IGNORE就好了
update IGNORE customer set capital_number = CONVERT(capital,SIGNED) where capital like '%测试数据%' and capital_number is null