Changing a characters zone through the DB?

[spyingeye]

Situation: I tried to zone into a zone that I did not have, so my game crashed to the desktop. I then was unable to log back in with that character, since it was trying to start in the zone I did not have. (My oun local server.)

Since I was still wanting to play that character I tried to modify the DB with a zone that I knew I had. But when I went back in to EQ that character was gone.

This is the SQL statement that I used: REPLACE INTO Character_ (id,account_id,name,profile,guild,guildrank,x,y,z, zonename,alt_adv) VALUES (5,1,’Tead’,’M_

[Trumpcard]

Would have been much easier to do

update character_ set zonename='zone' where name like '%Charactername%';

[spyingeye]

DOH! A simple update! DOH! Is there a good place to fine the commands that are acceptable in MySQL? I have used MSSQL allot but I relied too much on the interface to get commands, so I don’t have them off the top of my head. I have looked for a list of commands but could not find much even on the MySQL site. I may have just been overlooking them though.
I would also like to say this project is awesome I tried it out about 8 months ago and it is so much better now.

[Trumpcard]

Just do a google search for mysql tutorial... Just standard SQL for the most part...

[DeletedUser]

I use the 1 page per chapter doc on the mysql website. It can be found at:
http://www.mysql.com/documentation/mysql/bychapter/

Second to last link in that glossary is the SQL commands, Type and function definitions that are indexed by Name. http://www.mysql.com/documentation/mysql/bychapter/manual_Function_Index.html#Function_Index

I love that page when trying to figure out the type I need if it isn't a straight int or varchar.

[spyingeye]

Thanks this is exactly what I needed.