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 即可。