>I am sorry for posting the same question multiple times.
>
>I solved the problem: my text editor (EditPlus) has different
>file modes for PC, Unix and Mac. Although mySQL resides on win32
>platform (both server and client), the data file that is to be loaded
>using LOAD DATA INFILE .... has to be in Unix format?!? That has to do
>with the line endings, I guess, since mySQL recognizes \n as a line
>ending, but not wahetever Win uses... Lost half a day to figure out
>that.
Using the LINES TERMINATED BY option may help you out here.
Specifically, LINES TERMINATED BY "\r\n"
Check the syntax in the manual to see where it fits in the
statement.
--
Paul DuBois, paul@stripped
