10-20-2012, 04:36 PM
normal ? :
mysql> UPDATE t_npc SET a_exp = a_exp * 30;
UPDATE t_npc SET a_skill_point = a_skill_point * 1;
UPDATE t_npc SET a_prize = a_prize * 1;
# droptable
UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 40;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 40;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 40;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 40;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 40;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 40;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 40;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 40;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 40;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 40;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 40;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 40;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 40;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 40;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 40;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 40;
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 40;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 40;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 40;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 40;
Query OK, 913 rows affected
Rows matched: 1330 Changed: 913 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1330 Changed: 0 Warnings: 0
Query OK, 0 rows affected
Rows matched: 1330 Changed: 0 Warnings: 0
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1125 rows affected
Rows matched: 1330 Changed: 1125 Warnings: 1
Query OK, 1120 rows affected
Rows matched: 1330 Changed: 1120 Warnings: 1
Query OK, 1119 rows affected
Rows matched: 1330 Changed: 1119 Warnings: 1
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 0
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 0
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 0
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 0
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 0
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 0
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 1118
Query OK, 1118 rows affected
Rows matched: 1330 Changed: 1118 Warnings: 1118
mysql>

