有时导入mysql会提示如下错误:
C:\Users\liqiang>mysql -uroot -paaaaaa guangxi<e:\data\ticai.sql
ERROR 1064 (42000) at line 486: You have an error in your SQLsyntax; check the
manual that corresponds to your MySQL server version for the rightsyntax to use
解决办法是打开要导入的文件在里面搜索 BTREE 找到如下内容
KEY `columnCindex` (`columnC`) USING BTREE
修改为
KEY `columnCindex` USING BTREE (`columnC`),
然后就可以顺利通过了