架設Ea SQL 12716

盛夏

如題

我架設SQL  到要上傳 main 他出現

錯誤
SQL 語法 :  
CREATE TABLE `quest` (
`char_id` int( 11 ) unsigned NOT NULL default '0',
`quest_id` int( 10 ) unsigned NOT NULL ,
`state` enum( '1', '0' ) NOT NULL default '0',
PRIMARY KEY USING BTREE(
`char_id` ,
`quest_id`
)
)ENGINE = MYISAM
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 'USING BTREE (`char_id`,`quest_id`)
) ENGINE=MyISAM' at line 5


誰能幫幫我

£×ＳＫＹ﹋°

SQL版本不支援，

請刪除
PRIMARY KEY USING BTREE(
`char_id` ,
`quest_id`
)

盛夏

原帖由 £×ＳＫＹ﹋° 於 2008-10-25 11:17 PM 發表
SQL版本不支援，

請刪除
PRIMARY KEY USING BTREE(
`char_id` ,
`quest_id`
)

在哪刪除壓 main??

£×ＳＫＹ﹋°

better try than ask ！