[SQL ] #1064 - You have an error in your SQL syntax
最近開始學SQL指令,之前用了XAMPP架設了一個資料庫一直都沒有使用,所以就把它拿來
練習看看,但是,我執行我以前寫的指令,卻發生錯誤,不知道各位先進可以幫我看看嗎
?非常感謝。
CREATE TABLE `TestTable` (
`id` int(11) NOT NULL auto_increment,
`Taken` varchar(50) collate latin1_general_ci NOT NULL default '0',
`Name` varchar(50) collate latin1_general_ci NOT NULL default 'None',
`MOTD` varchar(50) collate latin1_general_ci NOT NULL default 'None',
`Color` varchar(50) collate latin1_general_ci NOT NULL default '0xFF000069'
`Members` varchar(80) collate latin1_general_ci NOT NULL default '0',
`Spawn0` varchar(16) collate latin1_general_ci NOT NULL default '1684.9',
`Spawn1` varchar(16) collate latin1_general_ci NOT NULL default '1684.9',
`Spawn2` varchar(16) collate latin1_general_ci NOT NULL default '1684.9',
`Spawn3` varchar(16) collate latin1_general_ci NOT NULL default '1684.9',
`Spawn4` varchar(50) collate latin1_general_ci NOT NULL default '1684.9',
`Interior` int(11) NOT NULL default '0',
`Money` int(11) NOT NULL default '0',
`Mats` int(11) NOT NULL default '0',
`Drug` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
MySQL 傳回:
#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
'`Members` varchar(80) collate latin1_general_ci NOT NULL default '0',
`Spawn0' at line 7
--
◣ ◢ HEY~~~HEY~~~CHAAAAARLIE~!
。。。。。 ◢ ▁ ◣ ⊙ ⊙
⊙ .◣ ▼▼▼▼
ㄟ◥ ㄧ◤ \▲▲▲▲
φ ◢ . \ . δ
./ㄨ \\/ˊ◥▄▄◤ \|/ㄑ ( ︶ ˋ\///\/. by Armour@joke
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.43.111.86
→
09/20 16:07, , 1F
09/20 16:07, 1F
推
09/20 17:07, , 2F
09/20 17:07, 2F
推
09/20 19:38, , 3F
09/20 19:38, 3F
→
09/20 20:29, , 4F
09/20 20:29, 4F
→
09/20 20:33, , 5F
09/20 20:33, 5F