[SOLVED] Help with MySQL Command Line - I'm going insane help me :D

[leevalentine001]

Ok, this is probably a terrible question and yes I'm a noob at this kinda stuff.

 

I'm trying to set up my own private server for World of Warcraft (have been for 3 days now actually). I've got everything perfect now except for one thing. In the guide I'm using, you need to make your in-game account using MySQL Command Line Client.

 

The code used in the guide must be out-dated because it says to use...

 

USE `accounts`; (that one works fine)

 

then..

 

insert  into `accounts`(`acct`,`login`,`password`,`gm`,`banned`,`lastlogin`,`lastip`,`email`,`flags`,`forceLanguage`) values (1,'username goes here','password goes here','az',0,'0000-00-00 00:00:00','','',8,'enUS');

 

I typed it and retyped it 100% correct (replacing the username and password of course) and I always get a 'syntax error'. Can anyone tell me what syntax I should use?

 

Thanks in advance.

[leevalentine001]

Anyone at all? Please help me I can't work this one out.

[PFMaBiSmAd]

I recommend using the mysql administrator and query browser GUI tools - http://dev.mysql.com/downloads/gui-tools/5.0.html

 

I would assume (I have never used the mysql command line) that the syntax error that is displayed also indicates where in the query the error was found? Posting that information from the error message would help.

[fenway]

What syntax error do yo uget?

[leevalentine001]

The error says...

 

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'accounts' etc etc.

 

Some told me that I should be using the tilde key (`) instead of the apostrophe (') is that right?

[leevalentine001]

Ok it was that I had to use the tilde after all 

 

Unfortunately I still have more errors with the private server but they're not SQL errors so I'll leave it at that.

 

Thanks for the help ^^