sql语句为:
LOAD DATA INFILE 'D:/StockCategory.txt' INTO TABLE stock_category character set utf8 FIELDS TERMINATED BY ',' lines terminated by '\n'
错误信息为:
[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 'character set utf8 FIELDS TERMINATED BY ',' lines terminated by '\n'' at line 1数据库及数据表编码均为“utf8”。
INSERT没有问题,LOAD DATA IN FILE报错。
谢谢大家。
LOAD DATA INFILE 'D:/StockCategory.txt' INTO TABLE stock_category character set utf8 FIELDS TERMINATED BY ',' lines terminated by '\n'
错误信息为:
[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 'character set utf8 FIELDS TERMINATED BY ',' lines terminated by '\n'' at line 1数据库及数据表编码均为“utf8”。
INSERT没有问题,LOAD DATA IN FILE报错。
谢谢大家。
解决方案 »
- 如何实现:当两人同时对mysql表中同一记录进行操作时,第二人进行更新时,会提示,此记录已再在被人操作.
- 执行这个存储过程怎么没有查出来值呢?我在mysql front下测试无值?
- CREATE TABLE 错在哪?
- 求 按分组把某字段连接起来的sql语句。请教
- 请各位帮忙---myql问题
- [MySql]Linux下安装的问题
- mysql查询里的中文条件问题 急!!!!
- MYsql的安装问题
- 如何修改set-variable= max_allowed_packet=8M?
- sql语法哪里写的不对-。-
- 如何配置Aptana与MySQL的连接
- mysql LOAD_FILE如何写中文路径和中文名称?
类似问题可以参考一下手册中的语法。
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码
load data...