mysql导入数据时提示 USING BTREE 错误解决办法

错误原因: 主要是是MYSQL 5.1的一个BUG,其出现原因是mysql 5.1和mysql 5.0在处理到索引语句时有所区别。案例: 有时导入mysql会提示如下错误: ERROR 1064 (42000) at line 486: 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, KEY `Reference_1_FK` (`RoleI...
posted @ 2013-10-31 14:20  zhangsir  阅读(579)  评论(0编辑  收藏  举报