这是输入的代码
修改智力
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