At 20:35 -0700 7/2/02, Martin Scherer wrote:
>I am trying to import a text file that is tab delimited.
>I am using the following , but it only returns one line.
>LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO
>TABLE Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
>Why would it do one line and then stop? MySQL indicates one line affected.
>The database is not empty and at first I suspected that the import
>stopped due to the same Customer_ID but that is not the case as the
>ID's for the first records do not exist in the database as they were
If the file really newline terminated? That may seem a silly question,
but not getting the line terminator correct will sometimes result in
the problem you're experiencing.
>Failure is an editorial judgement imposed by others