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 -- Failure is an editorial judgement imposed by others --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
