昨天mysql导入数据的时候出现了:
[Err] 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 'USING BTREE,
CONSTRAINT `出版教材表 出版序号` FOREIGN KEY (`Bookid`) REFERENCE' at line 9
通过上网查找,找到了解决方案:
打开要导入的文件在里面搜索Bookid 找到如下内容
KEY `专著类型引用` (`Bookid`) USING BTREE,修改为
KEY `专著类型引用` USING BTREE (`Bookid`) ,即把USING BTREE 放到索引字段前面即可.
再次导入顺利通过了