Re: single quote in data breaks file load

[Roland Bouman]

Steve, I usually also go for a workable solution first, and imporve afterwards if it's neccessary. A solution needs to be as good as is required. I just wanted to point out the usual way to do these things in case you do need to improve your solution.
Here's links to the relevant documentation:

http://dev.mysql.com/doc/mysql/en/load-data.html
and
http://dev.mysql.com/doc/mysql/en/mysqlimport.html