ERROR 1064 (42000): You have an error in your SQL syntax
来源:互联网 发布:北京数据堂公司英语 编辑:程序博客网 时间:2024/06/01 15:48
mysql使用load data infile导入数据。出现如下错误:
root@NoName 21:19:12> load data infile /change.csv' into table change CHARACTER SET utf8 fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\n'
-> (src_company_id,company_name,change_id,no,change_date,change_name,before,after,src_created_date,
src_updated_date);
ERROR 1064 (42000): 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 'before,after,src_created_date,src_updated_date)' at line 2
root@NoName 21:19:23>
原因在于,表字段使用了mysql保留字。mysql保留字晚上很多,这里就不列举了。before、after就是其中之一。
解决方法,在字段名上用尖引号括起来。如下:
`before`,`after`
阅读全文
0 0
- 1064 - You have an error in your SQL syntax问题解决
- Error 1064(42000):you have an error in your sql syntax;一个简单的原因
- 完美解决 ERROR 1064 (42000): You have an error in your SQL syntax ... near …
- ERROR 1064 (42000): You have an error in your SQL syntax
- You have an error in your SQL syntax
- MySql JDBC:You have an error in your SQL syntax;
- You have an error in your SQL syntax的解决方法
- 抛出 异常 You have an error in your SQL syntax...
- You have an error in your SQL syntax;解决方法
- You have an error in your SQL syntax;
- You have an error in your SQL syntax
- You have an error in your SQL syntax;
- You have an error in your SQL syntax;
- You have an error in your SQL syntax
- You have an error in your SQL syntax;
- 异常之You have an error in your SQL syntax
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- struts2值栈&struts ognl表达式---【小白系列】0基础到熟练应用struts2框架(四)
- MATLAB中 使用bar函数关于与x轴上label不齐的解决办法
- java文件没有在WEB-INF/classes中生成class
- 四、JAVA基础语法(2)
- Python---set集合类型操作总结
- ERROR 1064 (42000): You have an error in your SQL syntax
- AOP应用之------测试方法运行时间
- EA&UML日拱一卒-活动图::CallBehaviorAction
- java生成带二维码
- 数据类型
- Log4J.xml配置详解
- React Native 源码浅析
- java
- caffe下学习速率调整策略