I am going to use the LOAD DATA INFILE from PHP to allow users to bring a csv file into the database. I need to add an userId field to the stuff going into the database that's not in the csv file, is there any way I can just add something to the query to do this, or do I need to manipulate the csv file first? Here is the query:
LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';