title: comma separated values in mysql in to multiple rows
body: <p>I'm ahaving the  problem in mysql query,,I need mysql query for display the following output and also i need to take csv or excel or pdf report .</p>
  
  <h1>Table1:</h1>
  
  <pre><code>id : nos
  ---------
  1    12,13,14
  2    14
  3    14,12
  </code></pre>
  
  <h1>Table2:</h1>
  
  <pre><code>id : values
  ------------
  12   raja
  13   rames
  14   ravi
  </code></pre>
  
  <p>I want output like this:</p>
  
  <pre><code>id  values
  ---------------------
  1   raja
  1   rames
  1   ravi
  2   ravi
  3   ravi
  3   raja
  </code></pre>