魔兽世界单机navicat批量修改装备属性代码超出范围

原帖链接(如相关问题涉及本站资源，请给出原帖链接！)

问题截图

问题描述(如果本资源侵犯到您的权益，请联系在线管理员QQ：1589479632处理！)

用navicat修改item_template但是倍数超过6倍就会报错。这是我在国外唯一的乐趣了，求解决方法！！！！！

这是输入的代码
修改智力
UPDATE item_template SET
stat_value1 = stat_value1*10 WHERE stat_type1=5;
UPDATE item_template SET
stat_value2 = stat_value2*10 WHERE stat_type2=5;
UPDATE item_template SET
stat_value3 = stat_value3*10 WHERE stat_type3=5;
UPDATE item_template SET
stat_value4 = stat_value4*10 WHERE stat_type4=5;
UPDATE item_template SET
stat_value5 = stat_value5*10 WHERE stat_type5=5;
UPDATE item_template SET
stat_value6 = stat_value6*10 WHERE stat_type6=5;
UPDATE item_template SET
stat_value7 = stat_value7*10 WHERE stat_type7=5;


这是报错
mysql>
修改智力20倍
UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=5;
UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=5;
UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=5;
UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=5;
UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=5;
UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=5;
UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=5;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '修改智力20倍
UPDATE item_template SET stat_value1 = stat_value1*20 WHERE s' at line 1
1264 - Out of range value for column 'stat_value2' at row 27
1264 - Out of range value for column 'stat_value3' at row 190
1264 - Out of range value for column 'stat_value4' at row 8423
1264 - Out of range value for column 'stat_value5' at row 215
1264 - Out of range value for column 'stat_value6' at row 49714
Query OK, 0 rows affected
Rows matched: 0  Changed: 0  Warnings: 0

已解决。