读书人

LOAD DATA INFILE 语句异常

发布时间: 2012-03-04 11:13:33 作者: rapoo

LOAD DATA INFILE 语句错误
执行语句导入数据:
LOAD DATA INFILE 'e:\\load.txt'
INTO TABLE ms.tb_employee_info(id,name)
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

错误信息:
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 'LINES TERMINATED BY '\n'
IGNORE 1 LINES' at line 3

去掉最后两行能正常运行,实在是看不出哪里有问题了……

[解决办法]
其实MYSQL手册中就有这些语法。参考一下手册会了解很多东西。

MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html
[解决办法]
jf》。。嘻嘻

读书人网 >Mysql

热点推荐