RE: [PHP] CSV import
| From: | Jay Blanchard | Date: | Mon, 21 Jul 2003 17:48:51 +0000 |
| Subject: | RE: [PHP] CSV import | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-156097@lists.php.net to get a copy of this message | ||
[snip]
When using something like this:
LOAD DATA LOCAL INFILE '/tmp/phpKBjUWb' INTO TABLE
indoma FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\r\n'
How do I also insert a field not in the CSV. For example there are 8
fields
in the CSV and 9 in the table. I want the ninth field to be the name of
the
CSV file. How do I do this? Can't find any mention of it on mysql.com.
[/snip]
Instead of LOAD DATA INFILE see ....
http://www.php.net/fgetcsv
HTH!