Re: CSV import

* Thus wrote jwulff (johnw@orcasnet.com): > 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. My suggestion is to go here: http://www.mysql.com/documentation/lists.html Curt -- "I used to think I was indecisive, but now I'm not so sure."