CSV import
| From: | jwulff | Date: | Mon, 21 Jul 2003 17:42:08 +0000 |
| Subject: | CSV import | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-156094@lists.php.net to get a copy of this message | ||
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.
John