title: load multiple txt files into mysql
body: <p>I have more than 40 txt files needed to be loaded into a table in Mysql. Each file contains 3 columns of data, each column lists one specific type of data, but in general the format of each txt file is exactly the same, but these file names are various, first I tried <code>LOAD DATA LOCAL INFILE 'path/*.txt' INTO TABLE xxx"</code></p>
  
  <p>Cause I think maybe use <code>*.txt</code> can let Mysql load all the txt file in this folder. But it turned out no. </p>
  
  <p>So how can I let Mysql or python do this? Or do I need to merge them into one file manually first, then use <code>LOAD DATA LOCAL INFILE</code> command?</p>
  
  <p>Many thanks!</p>