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'
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
