PHP DB - Load Data infile help needed

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Load Data infile help needed

Chris Payne

2004-06-28, 8:56 pm

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

Sponsored Links