Load Data infile help needed

["Chris Payne" <chris_payne@xxxxxxxxxxxxxxxxx>]

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'");