Home >Database >Mysql Tutorial >mysql 1064 USING BTREE问题_MySQL
mysql 1064 USING BTREE问题_MySQL
- WBOYOriginal
- 2016-06-01 13:45:331178browse
bitsCN.com
从服务器上通过mysqldump命令导出文件
在导入到另外的库时，提示:
MySQL 返回：
#1064 - 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 `authorid` (`authorid`) USING BTREE,
KEY `dateline` (`datel' at line 24
经查找是mysql版本的问题,导入的库是 server version: 5.0.18，导出的库5.1.45.
打开导出的mysql文件,找到类似
KEY `authorid` (`authorid`) USING BTREE,
修改成
KEY `authorid`USING BTREE(`authorid`)
重新导入，问题解决。
作者“石膏娃娃”
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Mysqldump备份和恢复mysql数据库_MySQLNext article：MySQL中的insert ignore into, replace into等的一些用法总结_MySQL