At 22:35 -0800 1/27/02, Chris Williams wrote: >I'm trying to create a LOAD statement that will enable me to load both a >comma or tab delimited text file. I am only successful in achieving one or >the other by using: > "LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY >'\\t,' LINES TERMINATED BY '\\r\\n' >or >"LOAD DATA LOCAL INFILE mfile.txt INTO TABLE Temp FIELDS TERMINATED BY ',' >LINES TERMINATED BY '\\r\\n' > >I don't know however the proper syntax to include both field termination >parameters in one LOAD statement
You can't. > like I am able to do with line termination. You can't do that either. Your statements don't describe a termination string that's one or the other, they describe a termination string that requires both. > >Regards, >Chris Williams --------------------------------------------------------------------- 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
