日期:2014-05-16  浏览次数:20831 次

导入数据库错误
提示
ERROR 1064 at line 29: 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' at line 6

那一行
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


好像是mysql 版本太低, 从4.X导入到4.0
请问要如何改?

------解决方案--------------------
用文本编辑软件来替换 ENGINE=InnoDB 为 TYPE=InnoDB
------解决方案--------------------
ENGINE=InnoDB DEFAULT CHARACTER SET = utf8