title: Migrating table contents to the other table and changing the rules of the game Mysql
body: <p>I'm stuck yet again with mysql :)</p>
  
  <p>My issue is simple/complicated at the same time.</p>
  
  <p>I prepared dataset which contains columns:
  <code>user_id, user_email, user_country</code> .......</p>
  
  <p>I need to import/insert this into wp_usermeta table.</p>
  
  <p>wp_usermeta has following columns:</p>
  
  <pre><code>umeta_id (autoincrement), user_id, meta_key, meta_value
  </code></pre>
  
  <p>So from my dataset, user_id should be user_id, user_email and user_country become meta_keys and their content meta_values.</p>
  
  <p>In the end I expect to get this:</p>
  
  <pre><code>user_id   meta_key        meta_value
  12        user_country    Italy
  12        user_email      sa@sa.com
  </code></pre>
  
  <p>From the lack of correct word for this, I'm trying to "deconstruct" dataset.</p>
  
  <p>Possible with mysql? or should I do php script that will do this for me?</p>