sql code help

[Achmed]

I want to see about changing the sell price of items on my server, what sql code would i need to change just the sell price?

 

would this work?

SET sell = '[1,"ItemGoldBar",1]', sell = [3,"ItemSilverBar10oz",1];

i have no clue so its prob wrong so dont recommend anyone try it lol

[Kind-Sir]

I want to see about changing the sell price of items on my server, what sql code would i need to change just the sell price?

 

would this work?

SET sell = '[1,"ItemGoldBar",1]', sell = [3,"ItemSilverBar10oz",1];

i have no clue so its prob wrong so dont recommend anyone try it lol

UPDATE traders_data SET buy='[9001,"ItemBriefcase100oz",1]', sell='[4500,"ItemBriefcase100oz",1]' WHERE item='["AW159_Lynx_BAF",2]';

UPDATE - modify existing data in a table

traders_data - the table you want to modify

SET - the action you want to run

buy='xxx' - the argument

WHERE - for every occurance of

item='xxx' - where the item name = xxx

http://dev.mysql.com/doc/refman/5.0/en/update.html

[Achmed]

thanks. i had googled but didnt find anything i could understand :(

 

As i only want to change the sell price across the board (lowering the sell price to the buy price) would this work and change all [1,"ItemGoldBar",1] to [3,"ItemSilverBar10oz",1]?

UPDATE traders_data SET sell='[3,"ItemSilverBar10oz",1]' WHERE sell='[1,"ItemGoldBar",1]';

[Achmed]

just tested this on my test mysql and it works fine :)

 

thanks for your help

[Achmed]

well i ended up killing my server :(

can anyone see a problem with this code?

UPDATE traders_data SET sell='[1,"ItemCopperBar",1]' WHERE buy='[4,"ItemCopperBar",1]';

UPDATE traders_data SET sell='[1,"ItemCopperBar",1]' WHERE buy='[5,"ItemCopperBar",1]';

UPDATE traders_data SET sell='[2,"ItemCopperBar",1]' WHERE buy='[6,"ItemCopperBar",1]';

UPDATE traders_data SET sell='[2,"ItemCopperBar",1]' WHERE buy='[8,"ItemCopperBar",1]';

UPDATE traders_data SET sell='[3,"ItemCopperBar",1]' WHERE buy='[1,"ItemCopperBar10oz",1]';

UPDATE traders_data SET sell='[5,"ItemCopperBar",1]' WHERE buy='[2,"ItemCopperBar10oz",1]';

UPDATE traders_data SET sell='[8,"ItemCopperBar",1]' WHERE buy='[1,"ItemSilverBar",1]';

UPDATE traders_data SET sell='[2,"ItemCopperBar10oz",1]' WHERE buy='[2,"ItemSilverBar",1]';

UPDATE traders_data SET sell='[1,"ItemSilverBar",1]' WHERE buy='[4,"ItemSilverBar",1]';

UPDATE traders_data SET sell='[1,"ItemSilverBar",1]' WHERE buy='[5,"ItemSilverBar",1]';

UPDATE traders_data SET sell='[4,"ItemCopperBar10oz",1]' WHERE buy='[6,"ItemSilverBar",1]';

UPDATE traders_data SET sell='[2,"ItemSilverBar",1]' WHERE buy='[8,"ItemSilverBar",1]';

UPDATE traders_data SET sell='[3,"ItemSilverBar",1]' WHERE buy='[1,"ItemSilverBar10oz",1]';

UPDATE traders_data SET sell='[5,"ItemSilverBar",1]' WHERE buy='[2,"ItemSilverBar10oz",1]';

UPDATE traders_data SET sell='[8,"ItemSilverBar",1]' WHERE buy='[1,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[2,"ItemSilverBar10oz",1]' WHERE buy='[2,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[2,"ItemSilverBar10oz",1]' WHERE buy='[3,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[1,"ItemGoldBar",1]' WHERE buy='[4,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[1,"ItemGoldBar",1]' WHERE buy='[5,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[4,"ItemSilverBar10oz",1]' WHERE buy='[6,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[4,"ItemSilverBar10oz",1]' WHERE buy='[7,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[2,"ItemGoldBar",1]' WHERE buy='[8,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[3,"ItemGoldBar",1]' WHERE buy='[9,"ItemGoldBar",1]';

UPDATE traders_data SET sell='[3,"ItemGoldBar",1]' WHERE buy='[1,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[5,"ItemGoldBar",1]' WHERE buy='[2,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[8,"ItemGoldBar",1]' WHERE buy='[3,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[1,"ItemGoldBar10oz",1]' WHERE buy='[4,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[12,"ItemGoldBar",1]' WHERE buy='[5,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[12,"ItemGoldBar",1]' WHERE buy='[6,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[12,"ItemGoldBar",1]' WHERE buy='[7,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[2,"ItemGoldBar10oz",1]' WHERE buy='[8,"ItemGoldBar10oz",1]';

UPDATE traders_data SET sell='[3,"ItemGoldBar10oz",1]' WHERE buy='[1,"ItemBriefcase100oz",1]';

UPDATE traders_data SET sell='[5,"ItemGoldBar10oz",1]' WHERE buy='[2,"ItemBriefcase100oz",1]';

UPDATE traders_data SET sell='[8,"ItemGoldBar10oz",1]' WHERE buy='[3,"ItemBriefcase100oz",1]';

UPDATE traders_data SET sell='[1,"ItemBriefcase100oz",1]' WHERE buy='[4,"ItemBriefcase100oz",1]';

UPDATE traders_data SET sell='[12,"ItemGoldBar10oz",1]' WHERE buy='[5,"ItemBriefcase100oz",1]';

UPDATE traders_data SET sell='[2,"ItemBriefcase100oz",1]' WHERE buy='[8,"ItemBriefcase100oz",1]';

UPDATE traders_data SET sell='[3,"ItemBriefcase100oz",1]' WHERE buy='[12,"ItemBriefcase100oz",1]';

[Achmed]

Bump

[Bags2247]

Nah not me

[Kind-Sir]

Splice the query into parts of like 5 updates per query.
It may be that your MySQL server has a limit to the amount of commands you can pass in a query.

[axeman]

You can use CASE with mysql update queries.

http://www.headfirstlabs.com/sql_hands_on/hf24.htm

Take a backup first ;)