Re: Load data Input problem

2002-07-02 Thread Paul DuBois
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'

Load data Input problem

2002-07-02 Thread Martin Scherer
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 i