MySQL - phpMyadmin - Error #1064


MySQL - phpMyadmin - Error #1064

CREATE TABLE 'serverlist' (
'ID' int(4) NOT NULL auto_increment,
'Name' text NOT NULL,
'Number' text NOT NULL,
'BuyIn' DOUBLE NOT NULL default'0',
'BuyIn2' DOUBLE NOT NULL default'0',
'Limit' int(5) NOT NULL default'0',
'AvgPot' DOUBLE NOT NULL default'0',
PRIMARY KEY (id)
);

^这会导致以下错误:

#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 ''serverlist' ( 'ID' int(4) NOT NULL auto_increment, 'Name' text NOT NULL, 'Nu' at line 1

有什么想法吗?

用反引号更改简单引号:

CREATE TABLE `serverlist` (
`ID` int(4) NOT NULL auto_in
...