MySQL Forums
Forum List  »  CSV Storage Engine

Source file with list of path
Posted by: D'Auria Francesco
Date: May 13, 2010 09:51AM

Hi

I have this problem: i must to import a csv file with a list of path in my Mysql DB.
The file is like this:

"C:\Document\001\file1.jpg"
"C:\Document\001\file2.jpg"
"C:\Document\001\file3.jpg"
"C:\Document\001\file4.jpg"
"C:\Document\001\file5.jpg"

if i use the "load data" command in the table i have an output like this:

C:Document001file1.jpg
C:Document001file2.jpg
C:Document001file3.jpg
C:Document001file4.jpg
C:Document001file5.jpg

the character "\" is lost. I think the problem is that the character "\" is a special character for Mysql.
how can i do to solve this problem?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Source file with list of path
6420
May 13, 2010 09:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.