title: How to copy data from one table to another new table in MySQL?
body: <p>I want to copy data from one table to another in MySQL.</p>
  
  <p>Table 1 (Existing table):</p>
  
  <pre><code>aid    
  st_id
  from_uid
  to_gid
  to_uid
  created
  changed
  subject
  message
  link
  </code></pre>
  
  <p>Table 2 (New Table)</p>
  
  <pre><code>st_id
  uid
  changed
  status
  assign_status
  </code></pre>
  
  <p>I want to copy some fields of data from TABLE 1 into TABLE 2.</p>
  
  <p>Can this be done using MySQL queries?  </p>