MYSQL LOAD AND INSERT FILE NAME

Question

Im loading a csv file into a MySQL database using a load statement, can I in that same statement grab the filename and insert in a column called filename? like maybe declaring the filename then doing an update set right after

LOAD DATA LOCAL INFILE 'C:\Users\kpacheco.AD\Desktop\Projects\Wellcare\Weekly01272014\FINANCIAL\ RECOVERY\ GROUP\ -\ CONTESTATION\ 20140129.CSV' INTO TABLE TRACKING_INSERT FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '\r\n' ignore 1 lines;

Devart Devart · Accepted Answer · 2014-01-30T16:02:33

If LOAD DATA INFILE statement was supported by prepared statements in MySQL, then you could do it simple (here is a list of supported statements - Prepared Statements).

So, you should construct and execute your LOAD DATA INFILE... in application layer.

Example:

LOAD DATA INFILE 'data.csv'
  INTO TABLE table
  (column1, column2)
  SET column3 = 'data.csv';

MYSQL LOAD AND INSERT FILE NAME

1 Answers