Any SQL tutorials?

[Whyarp]

Does anyone have any links to decent SQL query tutorials..

Or could someone help by showing me how to change all the entry's for Mangos > Creature_Template > Scale from 1 to 3 in one hit..

Just having a bit of fun.. but couldn't find the right way to do it.. thanks.

[Patman128]

http://www.w3schools.com/sql/sql_intro.asp

[Daggo]

It would look something like this

USE mangos;

UPDATE Creature_Template

SET scale = 3;

run this in MySQLYog and hit 'F9'. Have fun.

[Whyarp]

Thank you, all sorted and Double day event started, lol..

3 was toooooo large so went for 2, probably could have got away with 1.5 but the players are having fun