title: Insert values from one column to another in the same table
body: <p>How can I <strong>insert</strong> values from one column to another in the same table? </p>
  
  <p>Say I have:</p>
  
  <pre><code>Date    |    Suburb    |    Suburb2
  010617       Sydney        Parammatta 
  010718       Melbourne     St Kilda
  </code></pre>
  
  <p>I require:</p>
  
  <pre><code>Date    |    Suburb    |    Suburb2
  010617       Sydney        Parammatta  #copy date and suburb2
  010718       Melbourne     St Kilda    #copy date and suburb2
  010617       Parammatta                #insert
  010718       St Kilda                  #insert
  </code></pre>
  
  <p>In other words, I want to copy 'Suburb2 and 'Date' and insert them as new rows in 'Date' and 'Suburb' respectively.</p>
  
  <p>I know I can achieve this by first copying into temporary column/s and cleaning up later but was wondering if there was a way to do this in one query?</p>
  
  <p>I tried</p>
  
  <pre><code>INSERT INTO table (date, suburb) SELECT (date, suburb2);
  </code></pre>
  
  <p>but got a <em>column "date" does not exist</em> error.</p>