Question

Navicat 8 for mysql运行sql文件错误1064

我在用Navicat 8 for mysql时运行sql文件出现了error1064，出错代码界面如下，应该怎么解决啊？是我的机子或者navicat有问题吗？

[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 `FK_AdminLogin` FOREIGN KEY (`loginID`) REFERENCES `l' at line 8
[Err] CREATE TABLE `admin` (
`adminID` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`loginID` int(10) NOT NULL,
`status` char(1) NOT NULL,
`del` char(1) NOT NULL,
PRIMARY KEY (`adminID`),
KEY `FK_AdminLogin` (`loginID`) USING BTREE,
CONSTRAINT `FK_AdminLogin` FOREIGN KEY (`loginID`) REFERENCES `login` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Answer 1

追问

安装了运行sql文件还是出现这个错误？是语句有问题吗？但是我朋友可以运行的啊、

追答

1064 -你有一个错误在您的SQL语法;检查手册,对应于你的MySQL服务器版本正确的语法使用附近的来使用,
约束的FK_AdminLogin外键(loginID)引用“l”在第8行