[SQL ] #1064 - You have an error in your SQL syntax

看板Database作者 (蘋果駐台辦事處處長)時間15年前 (2010/09/20 16:06), 編輯推噓2(203)
留言5則, 3人參與, 最新討論串1/1
最近開始學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
'0xFF000069' 後面要逗號..
09/20 17:07, 2F

09/20 19:38, , 3F
樓上正解,但是這個table真的開的好鬆散
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
文章代碼(AID): #1CbnNjPI (Database)