01-02-2014, 02:58 AM
UPDATE t_inven00 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven00 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven00 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven00 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven01 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven01 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven01 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven01 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven02 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven02 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven02 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven02 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven03 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven03 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven03 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven03 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven04 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven04 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven04 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven04 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven05 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven05 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven05 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven05 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven06 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven06 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven06 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven06 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven07 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven07 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven07 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven07 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven08 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven08 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven08 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven08 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven09 SET a_count0 = 0 + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count1 = 0 + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven09 SET a_count2 = 0 + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven09 SET a_count3 = 0 + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven09 SET a_count4 = 0 + "100" WHERE a_item_idx4 = 19;