Using Navcat to import MySQL data from someone else, the following error was reported:
[ERR] 1064-you has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use the USING BTREE
) Engine=myisam DEFAULT Charset=utf8 ' at line 9
The main reason for the error is database version inconsistency, which is also a bug in MySQL 5.1, because MySQL 5.1 and MySQL 5.0 differ when processing to index statements.
The solution is as follows:
Open the file you want to import search BTREE find the following key Typdid (typeid) using BTREE Modify the key typeid using BTREE (typeid), and then you can pass the
Check the installation of the MySQL version is 5.0, not much to say decisively unloaded the latest 5.7
Then execute the SQL file and import the database successfully.
MySQL Execute SQL file encountered using BTREE) Engine=myisam DEFAULT Charset=utf8 Error