Mysql: ON DUPLICATE KEY UPDATE ALL VALUES?

Question

Is there any easy way to update all values after a duplicate key? For example:

INSERT INTO published_books
           SELECT * FROM books
           WHERE book_id = book_id
           ON DUPLICATE KEY UPDATE ?everything?

The table has around 50 columns and updating each would be painful. Any ideas?

Answer 1

You can use REPLACE INTO for this purpose:

REPLACE INTO published_books SELECT * from books;