Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- mysql loads newline from flat file
March 28, 2007, 4:44 am
rate this thread
row, clearly its a newline or ENTER character.. I have tried
dos2unix.exe, a perl program that converts dos files to unix, etc.
But I dont think I cant remove newline from the file otherwise how
will mysql know what the record separator is ? here is my load
LOAD DATA INFILE 'e:/ETL/john/mergedfile_CELL2.txt' INTO TABLE
mergedfile_CELL1b FIELDS TERMINATED BY 0x1C IGNORE 1 LINES;
How does one resolve this ?
Re: mysql loads newline from flat file
Have you looked at the documentation of the LOAD DATA command? I believe
there is a query option to specify the line termination style, at least
there is for the record seperator. Usually for Unix/Linux it's only
'\n', but I believe it could be '\n\r' or '\r\n' for Windows (I'm not
sure if it is the first or the second option for Windows).
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum