RE: load strips first character

2004-04-28 Thread Victor Pendleton
The backslash, `\` is an escape character. Four backslashes, path will be recognized as \\path in MySQL. -Original Message- From: Nik Belajcic To: [EMAIL PROTECTED] Sent: 4/28/04 1:38 AM Subject: load strips first character Hello, I am loading data from a text file where filed3 is a

load strips first character

2004-04-27 Thread Nik Belajcic
Hello, I am loading data from a text file where filed3 is a path to a document in a format "\\path\to\some\directory" but after loading into MySQL it appears as "\path\to\some\directory" with the first backslash stripped away. Why is this happening and how can I avoid it? LOAD DATA INFILE '/local