[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
来源:互联网 发布:网络黄金egd是怎么回事 编辑:程序博客网 时间:2024/05/13 00:53
[Err] 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 at line 3
MySQL 5.6,Navicat For MySQL 10.0.10 中执行SQL语句时提示此错误,在CMD中执行SQL文件中的语句时提示以下错误:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 1
- 2
- 3
- 4
- 5
- 6
- 7
解决方案:
发现解决该问题的关键,是错误提示中的空格都是“聽”,这让我想到是文件的编码问题,然后做文件编码的转换。
推荐使用Notepad++,编码转换非常方便,如图:
转换为UTF-8格式,问题依旧,再转为ANSI格式试试:
哈哈,原形毕露了吧!把?都替换为空格,保存,再执行,一切OK了。
反思:
为什么会出现这种问题呢?
这些语句是从QQ复制到Word中,双从Word中复制到Notepad++中,
估计是从QQ或Word中复制出来的空格有问题。
0 0
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
- Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL se
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds...
- 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
- MySql-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server v
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versi
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL的问题
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
- 错误信息:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ve
- ZooKeeper系列之三:Zookeeper常用命令
- 解决mysql中只能通过localhost访问不能通过ip访问的问题
- Android实现网络多线程断点续传下载
- UOJ 67 新年的毒瘤 (tarjan算法求割点)
- Execution failed for task ':app:transformNative_libsWithStripDebugSymbolForDebug'.
- [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL s
- 最小生成树的板子--Kruskal
- [校内模拟]最小生成树(Tarjan)
- 数据库学习笔记和小练习(14)函数
- RGB与HSV模型间的转换程序 RGB与HLS模型间的转换程序
- 简述安卓4种启动模式
- 关于安卓开发当中通过java自带的HttpURLConnection访问XML的java.io.EOFException问题
- HTML常用标签整理(h类)
- openjudge9269:Big String超级字符串 详解