title: Load csv into MySQL, using a new table
body: <p>I am using <code>phpMyAdmin</code> to load a CSV file into a MySQL table but, does the table have to be created before the load? </p>
  
  <p>I have read that if the workbench is used ( <a href="https://stackoverflow.com/questions/29672309/import-a-csv-file-into-mysql-workbench-into-a-new-table-dynamically">Import a CSV file into MySQL workbench into a new table dynamically</a> ) the latest version creates the table on the fly but, is this possible with <code>phpMyAdmin</code>.
  Here is the code that doesn't work</p>
  
  <pre><code>load data local infile '/Users/...'
  into table skin_cutaneous_melanoma
  fields terminated by ','
  lines terminated by '\n'
  </code></pre>
  
  <p>Error is: </p>
  
  <pre><code>#1146 - Table hospital.skin_cutaneous_melanoma' doesn't exist 
  </code></pre>