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