加载数据文件，Windows和Linux之间的差异 [英] Load data infile, difference between Windows and Linux

问题描述

我有一个文件，需要导入到MySQL表中.这是我的命令

I've a file which I need to import to MySQL table. Here's my command

LOAD DATA LOCAL INFILE 'C:\test.csv'
INTO TABLE logs
fields terminated by '|'
LINES terminated BY '\n'

在Windows中看起来不错，但是在Linux中，它仅插入第一行并在日志文件中生成错误

This looks fine in Windows, but in Linux it inserts only the first row and generates an error in log file

LOAD DATA LOCAL INFILE '/home/myuser/test.csv'
INTO TABLE logs
fields terminated by '|'
LINES terminated BY '\n'

我需要在Linux中进行哪些更改?

What I need to change in Linux?

推荐答案

我已经在Windows 8.1中使用mysql 5.6.17测试了此"LOAD DATA INFILE".下面是表格格式

I've tested this "LOAD DATA INFILE" in windows 8.1 using mysql 5.6.17. Below is the table format

+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+ 
| id        | int(11)     | NO   | PRI | NULL    | auto_increment |
| charactor | varchar(30) | YES  |     | NULL    |                |
| movie     | varchar(30) | YES  |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+

LOAD DATA LOCAL INFILE 'C:/Users/kaviranga/Desktop/scifi.csv' INTO TABLE scifi FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 0 LINES (charactor,movie);

这非常有效，我使用的csv文件格式如下

This worked perfectly and the csv file format I've used as below

"Soldier 2","Pirates of the Carribian 2"
"Soldier 1","Pirates of the Carribian 4"

请勿像下面那样使用，否则可能会导致错误.

Don't use like below.It may causes errors.

'C:\Users\kaviranga\Desktop\scifi.csv'

我已将此答案包括在内，以供将来参考.

I've included this answer for future reference.

这篇关于加载数据文件，Windows和Linux之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！