LOAD DATA LOCAL INFILE 'C:/Documents and Settings/won/My Documents/summary.txt' INTO TABLE spacedx.summary FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (groupID,structural,mechanical,electrical,safety,vertical,misc)\
I'll save the trouble of cutting and pasting the output because it's really long. The carriage return in all the fields except groupID causes the line to terminate and I get about 6 times as many INSERTS than it should be. -----Original Message----- From: Christopher Book [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 4:31 PM To: '[EMAIL PROTECTED]' Subject: Text qualifiers >I tried to wrap the text in double quotes to tell it not to terminate the line. However, my imports have still failed. This could be due to my lack of experience or wrong syntax. But I did everything as told in the documntations. What parameters are you using for your import? If you give us a sample output record and your input command people here can usually find the problem. Chris table, sql, query --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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