Source file with list of path
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
Subject
Views
Written By
Posted
Source file with list of path
7110
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.