title: Batch script loop through CSV files into MySQL
body: <p>How can I loop through the files in a directory (they are all CSV files), and then log into mysql with <code>mysql -u root</code> (no password for sake of simplicity) and add them all to a mysql table? This is the query that loads files into mysql fast:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE "C:/prog/mydb_load_Cards_chunks.dump" INTO TABLE vcc2.tmp_cards CHARACTER SET latin1
  FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;
  </code></pre>
  
  <p>How can I do this for every file in a directory while being logged into mysql?</p>