magento数据库导入错误 - ERROR 1064 (42000) at line 382: 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

magento导数据库又遇一个错误:

ERROR 1064 (42000) at line 382: 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 `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
KEY `FK_CATALO' at line 9

解决办法是,搜索

UNIQUE KEY `IDX_BASE` (`entity_type_id`,`entity_id`,`attribute_id`,`store_id`) USING BTREE

替换为

UNIQUE KEY `IDX_BASE`USING BTREE
(`entity_type_id`,`entity_id`,`attribute_id`,`store_id`)

重新导入问题解决。

 

小知识:

解决USING BTREE带来的错误的处理办法一般都是

UNIQUE KEY `field1` (`field2`) USING BTREE ,修改为

UNIQUE KEY `field1` USING BTREE  (`field2`) ,

即把USING BTREE 放到索引字段前面即可.

 

 

本文永久地址:https://sjolzy.cn/magento-database-import-error-ERROR-1064-42000-at-line-382-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-39-USING.html

--EOF--

随机文章

仅有一条评论

  1. 学习了!

添加新评论