此错误因为mysql版本的问题,mysql5.0和mysql5.1在处理到索引语句时有所区别
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,搜索所有表的创建语句,查找关键字"USING BTREE"
解决方法:
把USING BTREE移到字段名的前面
例如:
KEYFK36EBCBFFF5E7D0
(EmployeeId
) USING BTREE
修改为:
KEY FK36EBCBFFF5E7D0
USING BTREE (EmployeeId
)