| List: | MySQL on Win32 | « Previous MessageNext Message » | |
| From: | James Frankman | Date: | August 27 2003 5:37pm |
| Subject: | importing text file with '\' in data fields | ||
| View as plain text | |||
I am trying to import a text file into MySQL using the Load date infile command, and am having trouble importing data that contains the '\' character. I have tried the escape by '\\' clause, but it did not help. The data always comes into MySQL without any backslashes. Is there a way to correctly import a text file with '\' characters into MySQL?
| Thread | ||
|---|---|---|
| • importing text file with '\' in data fields | James Frankman | 27 Aug |
| • RE: importing text file with '\' in data fields | Charles Mabbott | 27 Aug |