title: Mysql: ON DUPLICATE KEY UPDATE ALL VALUES?
body: <p>Is there any easy way to update all values after a duplicate key? For example:</p>
  
  <pre><code>INSERT INTO published_books
             SELECT * FROM books
             WHERE book_id = book_id
             ON DUPLICATE KEY UPDATE ?everything?
  </code></pre>
  
  <p>The table has around 50 columns and updating each would be painful. Any ideas?</p>