querying sql using sqlyog

hi ...i don't post very much and when i do post its usually after extensive research on my own ...

i have searched all over this forum and haven't found it...

But, what i need is to learn how to query in sqlyog to change cool times for potions and delay times for weapons.

Yes, i could do it one at a time but that is very extensive work not that i mind that except for i forget which i have changed and which i have opted to leave alone.


i play the server by myself so i want to learn how to query not have it done for me as i feel its more fun learning than actually playing the game ...so if you could please tell me how i should type this into the query window to change specific fields all help appreciated thx everyone :tongue:

thx for the help anyway i know you guys are busy but i found it in an old post and FTR: i will post what i found so others can see


to change specific fields in a batch type command just type

update "field name" (without quotes) set "field name" = arguement

example UPDATE item_template SET delay = delay /2 it should be similar to that

where delay would be divided in half ...that is the attack speed of weapons by the way ...well some of them anyway