title: How do I move data from one table into another in MySQL?
body: <p>I have the following query which pulls 1000 rows of data:</p>
  
  <pre><code>select barcode, type from collections where user = 'myusername'
  </code></pre>
  
  <p>I need to move this data to my new <code>collectors_collections</code> table. The <code>user</code> column is now labeled <code>username</code>.</p>
  
  <p>What is the quickest way to do this? A query of some kind or some other way? I am using the latest MySQL Workbench.</p>