title: Mysql Query - Copy resultset from one database to another
body: <p>I have a large db that I am chopping into smaller databases based on time intervals.  This will reduce query time dramatically.  In a query can I copy a resultset from one database to another with an identical schema?</p>
  
  <p>Basically a select followed by an update conducted in the same code block?</p>
  
  <p>Thanks,</p>
  
  <p>slothishtype </p>