Re: Can LOAD DATA ignorecharacters normally needing escapes inside fields?
DaveO <[email protected]> Sun, 22 Apr 2007 02:32:52 -0500
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
Todd Farmer wrote: > DaveO wrote: snip >> Is there a way to have LOAD DATA INFILE not pay attention to the >> contents of a field when loading it? > > Have you already tried using ... FIELDS ESCAPED BY '' ... ? > That makes sense, since the default is FIELDS ESCAPED BY '\'. And it works. Thanks. Dave -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]