List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 3 2002 3:59am
Subject:Re: Load data Input problem
View as plain text  
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 
>deleted records.

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.

>
>Thank you
>Martin
>--
>Failure is an editorial judgement imposed by others

Thread
Load data Input problemMartin Scherer3 Jul
  • Re: Load data Input problemPaul DuBois3 Jul