title: MySQL: Get a return result from an INSERT SELECT
body: <p>I have query that INSERTS both explicit values and SELECTd content. I'm also doing basic incrementing.</p>
  
  <pre><code>INSERT INTO `table` (`myID`, `myVal1`, `myVal2`) SELECT `myID` + 1, 'explValHere', 'otherValThere')
  FROM `table` ORDER BY `myID` DESC LIMIT 0,1
  </code></pre>
  
  <p>I am doing this as the table has multiple id's and incrementing within a specific column. So I can't, as you would first say, use auto incrementing and insert_id.</p>
  
  <p>The problem of course is the insert doesn't return the select, but can it? Is there a way of running this insert query and returning any of the result?</p>