title: load tab delimited data into mysql
body: <p>I need to load a text file tabDelimited/csv directly into mysql as table. I am following the page (https://dev.mysql.com/doc/refman/5.5/en/loading-tables.html) for doing the same.</p>
  
  <h2>testfile.txt</h2>
  
  <pre><code>field1,field2
  "abc",1
  "def",2
  "ghi",3
  </code></pre>
  
  <p>However, I keep getting the following message:</p>
  
  <pre><code>mysql&gt; LOAD DATA INFILE 'testfile.txt' INTO TABLE myTable IGNORE 1 LINES;
  ERROR 1146 (42S02): Table 'test.myTable' doesn't exist
  </code></pre>
  
  <p>I see that 'load' can be used only after creating the table. So the error is expected. I have multiple files and I need to avoid creating tables one by one. Is there any other way to do the same. </p>