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