title: SQL SELECT and INSERT statements together
body: <p>If I have a table, called <strong>Places</strong> with several fields, and a primary key placeID, what if the best way to INSERT a new item into the table, such that placeID is autoincremented, but all the other fields are the same as the item with placeID= 001,say.</p>
  
  <p>This is what I am doing</p>
  
  <pre><code> SELECT* FROM Places WHERE placeID = 001 ... 
   INSERT INTO Places VALUES(...should be values from previous select)
  </code></pre>
  
  <p>but I can't quite figure out how to do it.</p>