CSV import
This is a discussion on CSV import within the PHP General forums, part of the PHP Programming Forums category; When using something like this: LOAD DATA LOCAL INFILE '/tmp/phpKBjUWb' INTO TABLE `indoma` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
07-21-2003
|
|||
|
|||
CSV import
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 
|
Linear Mode
