title: PHP MySQL Copy a row within the same table... with a Primary and Unique key
body: <p>My table has two keys, one is an auto incrementing id (PRIMARY), the other is the name of the item (UNIQUE).</p>
  
  <p>Is it possible to duplicate a row within this same table? I have tried:</p>
  
  <pre><code>INSERT INTO items
  SELECT * FROM items WHERE id = '9198'
  </code></pre>
  
  <p>This gives the error <code>Duplicate entry '9198' for key 'PRIMARY'</code></p>
  
  <p>I have also tried:</p>
  
  <pre><code>INSERT INTO items
  SELECT * FROM items WHERE id = '9198'
  ON DUPLICATE KEY UPDATE id=id+1
  </code></pre>
  
  <p>Which gives the error <code>Column 'id' in field list is ambiguous</code> </p>
  
  <p>And as far as the item name (UNIQUE) field goes, is there a way to append <code>(Copy)</code> to the item name, since this field must also be unique?</p>