Basic SQL Scripting Guide

**~~R0flz0r~~** · 03-21-2008

Ok im pretty bored so i decided to make a guide on how to do some changes to the database without looking everything up, this can really spare u some time.

Lets say u want to remove something then it would be
DELETE from <tablename> where <collum> = <ID of what u want removed>; <-- the ";" simple just stops the query allowing u to upload more queries at the time

Example:
DELETE from items where entry = 31332;
the query above would complety remove Blinkstrike from the game

Lets take another example:
DELETE from vendors where item = 31332;
the query above would complety remove Blinkstrike from all vendors, but it would still be able to get by drops.

Ok now a how to add queries to the database
INSERT into <Tablename> ('<first collum>, '<second cullom>') values (<what u want in the first cullom>, <..in the secound cullom>,);

Example:
insert into `spell_disable` (`spellid`, `replacement_spellid`) values (5, 0);

You can also do it the abit "faster" way but that wouldnt match all revs

Insert into spell_disable VALUES (5, 0);
the query above inserts a spell into the spell_disable table which would be disabled and unable to be used

----
Now how to update rows

UPDATE items set sellprice = 10000 where entry = 31332;
the query above would set the sellprice for blinkstrike to 10000copper

Now if u want to set the sellprice to 10000copper for every single item
UPDATE items set sellprice = 10000 where entry between 1 and 9999999999;
You can also use the query above to remove the cost from all spells and skills (nice for funservers)

I guess thats all you need to know feel free to ask questions

Written by R0flz0r and only R0flz0r | Credits to R0flz0r and only R0flz0r