[請益] MySQL中CREATE TABLE語法出現錯誤?
CREATE TABLE `credit_s_file1` (
`chk` varchar( 2 ) NOT NULL default '0',
`number` varchar( 2 ) NOT NULL default '',
`c_s_f_id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`s_id` varchar( 12 ) NOT NULL default '',
`cs_num` varchar( 10 ) NOT NULL default '',
PRIMARY KEY ( `c_s_f_id` )
)ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1279
語法是原本的TABLE直接匯出的
然而想要搬到另一台卻出現:
MySQL 傳回：
#1064 - You have an error in your SQL syntax near
'ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1279' at line 14
這是什麼問題呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.124.101.153
推
12/25 18:54, , 1F
12/25 18:54, 1F
→
12/25 18:54, , 2F
12/25 18:54, 2F
→
12/25 18:55, , 3F
12/25 18:55, 3F
推
12/25 19:01, , 4F
12/25 19:01, 4F
推
12/25 19:16, , 5F
12/25 19:16, 5F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
5
22
