title: MySQL: Insert one column data to another
body: <p>I'm not soo good at MySQL. But want to improve it a bit, to be able to manipulate tables without serverside languages.</p>
  <p>I have one table and two columns. I need to select data from one column and insert in the same table as rows instead.</p>
  <p>As I understand I need to select this column data, save it in a temporary table or variable, then loop through results and insert them. But I do not know how to do it.</p>
  <p>Could someone help with a simple example.</p>
  <p>Thanks ;)</p>
  <hr />
  <p>My table:</p>
  <pre><code>id | col1 | col2
  -----------------
  1  | txt  |  txt4
  2  | txt2 |  txt5
  3  | txt3 |  txt6
  </code></pre>
  <p>I need to merge col1 and col2.</p>
  <p>Final result:</p>
  <pre><code> id | col1
  -----------
   1  |  txt
   2  |  txt2
   3  |  txt3
   4  |  txt4
   5  |  txt5
   6  |  txt6
  </code></pre>