Bug #51911 Load date infile should support Windows EOL
Submitted: 10 Mar 2010 13:17 Modified: 13 Jun 2011 17:27
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:* OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[10 Mar 2010 13:17] Olaf van der Spek 
Description:
Load data infile currently considers \r part of the data to input. This is probably always not what the user intends, so it'd be great if this statement could support Windows EOLs (\r\n) in addition to Unix EOLs (\n).

How to repeat:
load date infile '/home/olaf/n.txt' into table n;
[28 Sep 2010 13:44] Susanne Ebrecht 
Many thanks for a reasonable feature request.
[13 Jun 2011 17:26] Chris Wagner 
It already does.

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES;

http://dev.mysql.com/doc/refman/5.5/en/load-data.html
[13 Jun 2011 17:27] Olaf van der Spek 
I meant automatically.