CREATE TABLE album\_floar (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
album\_pic\_toto INT( 10 ) NOT NULL DEFAULT '0',
album\_name VARCHAR( 200 ) NOT NULL DEFAULT '',
add\_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY ( id ) ,
KEY album\_pic\_toto ( album\_pic\_toto ) ,
KEY album\_name ( album\_name ) ,
KEY add\_time ( add\_time )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =7
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 'DEFAULT CHARSET=utf8 AUTO_INCREMENT=7' at line 31
我是從 MySQL 客戶端版本: 5.1.48 匯出
要匯入 MySQL 版本 4.0.18-log
請問該如何修正這個錯誤 謝謝
gfskywing提到:
ENGINE = MYISAM
請把 ENGINE = MYISAM 改為 TYPE = MYISAM 即可。