title: Sql insert select from – multiple rows with unique column id
body: <p>I am trying to copy multiple records using one query using insert select from. </p>
  
  <pre><code>Insert into tab_A(colId, col1, col2, col3)
  Select colId, col1, col2, col3  form tab_A
  Where colId in ( 2,4,6)
  </code></pre>
  
  <p>Would it be possible to assign different colId for new entries? For example colid 2 should be replaced with 23, 4 with 24 and 6 with 25.  How could I achieve it in a single query? </p>