thanks to non-standard MS file formats I spent 2 hours trying to import a txt file into mysql on a linux box. I had the LINES TERMINATED BY ‘\n’ set, but it was still giving me carriage returns in my table. rar!

I dug into the documentation and found a little bit that said something like:

“Some MS text file formats require you to terminate the lines with ‘\r\n’. This is because MS, for some reason, wants to put a carriage return AND a line break at the end of each line.”

yay.

This entry was posted on Thursday, July 28th, 2005 at 8:47 am and is filed under computers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.