Rates Problems ...

[dateone]

UPDATE t_npc <- which table is to be changed, in this case the table t_npc

SET a_exp <- which column is to be updated/changed

= a_exp * 2 <- how it is to be changed, here: current exp multiplied with 2

 

That means if you want to change the exp from x200 to x1 then you have to type this into the console:

 

UPDATE t_npc SET a_exp = a_exp / 200;