title: copy several mysql rows based on foreign key
body: <p>I want to copy several rows in a mysql table based on a foreign key, and asign the new rows a new foreign key ID.  Assuming my table layout looks like this:</p>
  
  <p><code>test</code><br>
  <code>-----</code><br>
  <code>table1_id int(11)</code><br>
  <code>value varchar(20)</code><br></p>
  
  <p>How do I accomplish this? </p>