Hi all,
How to use MySQL LOAD DATA command to load comma separated text data
but one of the field can contains comma character as part of of the string context.?
In other word, I want LOAD DATA insert string with comma characters inside it but
without
adding slash character ('\')to distinguish it as a field separator.
I use this command,
LOAD DATA LOCAL INFILE "DATA.TXT" REPLACE INTO TABLE tbl
FIELDS TERMINATED BY "|" IGNORE 1 LINES
but when I look at the table tbl, everything is fine except
in the field that contain comma character, comma charater is written as '\,' rather
than just ','.
What option of LOAD DATA should I use?
Jamal
