Simple Sql trouble

[Kokko]

I was just woundering whats wrong when I get this errorcode in xampp when trying to load my sql database.


Fråga=Question Sa=Said.



SQL-fråga:

CREATE TABLE "server_config"(
"config"VARCHAR( 35 ) NOT NULL DEFAULT '',
"value"INTEGER NOT NULL ,
UNIQUE (
"config"
)
);







MySQL sa: Dokumentation
#1064 - 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 '"server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER ' at line 1

 

[Zisly]

Try:

CREATE TABLE `server_config` (
  `config` varchar(35) NOT NULL DEFAULT '',
  `value` int(11) NOT NULL ,
UNIQUE (
`config`
)
);

 

[Kokko]

Thanks for the help!

one problem though how do i add it do i make a new sql table or open the sql file with notepad?


Thanks


Tried entering it but cant get it to work.


I have used SQlitestudio to extract my database into a sql file. The database is from my s3db file.

 

[Kokko]

Im changing my question abit. How do I ad "otserver".killers table, i seem to need it for Modern AAC.

Im switching server base completley.