mysql版本5.5.31加载数据infile语法错误

Question

我想加载到云主机上的mysql表中的文件，但它是扔我语法错误。我的mysql版本是5.5.31。

mysql -u ykd202 -p -e 'LOAD DATA INFILE "home/folks/kosh/intx.csv" into TABLE history COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATE BY '\n' IGNORE 1 LINES;' f2014

在上述语句中，f2014是数据库名称。而我得到的错误是

Enter password: 
ERROR 1064 (42000) at line 1: 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 ' optinally enclosed by ' escaped by ' lines terminated by n ignore 1 lines' at line 1 

Answer 1

您发布的代码如下：

mysql -u ykd202 -p -e 'LOAD DATA INFILE "home/folks/kosh/intx.csv" into TABLE history COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATE BY '\n' IGNORE 1 LINES;' f2014 

但是，您的错误信息自相矛盾：

ERROR 1064 (42000) at line 1: 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 ' optinally enclosed by ' escaped by ' lines terminated by n ignore 1 lines' at line 1

1A）的错误的部分：optinally enclosed by - “optinally”拼写错误，应该是“可选”。

1B代码的）部分：OPTIONALLY ENCLOSED BY '"'

然后 ...

2A）错误的部分：lines terminated by n和

2B）代码的部分：LINES TERMINATE BY '\n' - 缺少D在TERMINATE结尾，应该读作TERMINATED。

所以，我将在这里熄灭的肢体，并说，你需要修改代码为：

mysql -u ykd202 -p -e 'LOAD DATA INFILE "home/folks/kosh/intx.csv" into TABLE history COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;' f2014 

---

• Read the manual on the subject

---

编辑：

尝试也：

mysql -u ykd202 -p -e "LOAD DATA INFILE 'home/folks/kosh/intx.csv' into TABLE history COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;" f2014