title: mysql INSERT INTO ... SELECT
body: <p>I want to select one row in a table and insert it into another table like this:</p>
  
  <pre><code>INSERT INTO  positionenneu
  select *
  from positionenneu_0603 where belegnummer like '4106192%'
  </code></pre>
  
  <p>I got an error because of duplicating id values. In both tables is id primary key AUTO_INCREMENT.
  How can I do this without id column?
  Thank you for the answer.
  Have a nice day!</p>