导入数据库错误
提示
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