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.

Thank you Martin