title: MySQL: create a different partition for each ID inside a trigger
body: <p>I read about partitioning in MySQL, and would like to know how to use this in my situation:</p>
  
  <p>I have a project where I store huge csv-files inside a database. </p>
  
  <p>For this I have one table <code>'csvfiles'</code> and another table <code>'csvdata'</code>.</p>
  
  <p>Queries are only made on one csv-file at the time, so my idea is to create a new partition in <code>csvdata</code>  <em>for each different primary key-value</em> in <code>csvfiles</code> every time a csv-file is added. 
  Ideally this should be done automatically, inside a trigger would be great.</p>
  
  <p>Could anybody tell me if this is a valid setup, and how this could be realized?</p>