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 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/datadocument.txt' INTO TABLE tdocument FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, field2, field3); Thanks, -- Nik Belajcic <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
