Search code examples
mysqlwildcardload-data-infile

MySQL load command: is there a wildcard available for the datafile?

I have the following file dumped daily into one of our online directories:

dat-part2-489359-43535-toward.txt

The numbers change each day randomly.

I have the following code to try and LOAD the file:

mysql_query("LOAD DATA LOCAL INFILE 'dat-part2-%-toward.txt' 
          REPLACE INTO TABLE my_table
          FIELDS TERMINATED BY ',' ENCLOSED BY ''
          LINES TERMINATED BY '\r\n'
          IGNORE 1 LINES") or die(mysql_error());

And of course no luck. What's the best way to do this?

Solution

  • assuming this is a scheduled job, why not check the directory for the most recent file that matches your filename template. Store the name of said file in a variable and then sub the variable into your query. Check out glob()