title: MySQL - copy records over to another table and remove existing one
body: <p>I'm trying to process the following in one sql statement - I want to copy the number of records to the archive table and straight away remove the existing ones from the main table.</p>
  
  <p>Something like:</p>
  
  <pre><code>INSERT INTO `table_archive` 
  SELECT * FROM `table_main`
  WHERE `id` IN (1, 2, 3, 4)
  REMOVE FROM `table_main` WHERE `id` IN (1, 2, 3, 4)
  </code></pre>
  
  <p>It's basically like cutting and pasting records from one table to another.</p>
  
  <p>Obviously the above statement is just what I want to achieve - any idea if it's achievable at all and what sql statement would it be?</p>