title: MySQL Copying table data with on duplicate key update using INSERT... "field id is ambiguous?"
body: <p>Im trying to copy contents from one table to another, both having identical table structure.</p>
  
  <pre><code>INSERT INTO master SELECT * FROM slave
    ON DUPLICATE KEY UPDATE id=id+1
  </code></pre>
  
  <p>This gives the error:
  <code>#1052 - Column 'id' in field list is ambiguous</code></p>
  
  <p>Seems like a simple problem but I can't resolve it. Does anyone know hot to fix this? </p>