Hi there everyone,
I'm having a problem loading in a text file, each column is enclosed with a
" and separated by a , but when I try the below, it loads in the data BUT it
puts a " to the left of each character.
Any help would be really appreciated.
Thank you
Chris
mysql_query("LOAD DATA INFILE 'c:/apache/htdocs/example/20040624.txt' INTO
TABLE import FIELDS
TERMINATED BY '\\\"' ESCAPED BY '\\,' LINES TERMINATED BY '\\r\\n'");
