Load Data infile help needed
| From: | Chris Payne | Date: | Mon, 28 Jun 2004 22:20:03 +0000 |
| Subject: | Load Data infile help needed | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35028@lists.php.net to get a copy of this message | ||
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'");