Entry

Why do I get lots of backslashes when I use "SELECT ... INTO OUTFILE"?

Why does "INTO OUTFILE" escape backslashes?

Feb 8th, 2000 05:35
Nathan Wallace, Michael Widenius

This is completely normal!  The reason for this is that INTO OUTFILE
escapes all escape characters (\ by default) to make it possible to read
the data back with LOAD DATA INFILE...

Fix:  Use 

    ... INTO OUTFILE... ESCAPED BY "" ...