MySQL的:在重复键更新所有值? [英] Mysql: ON DUPLICATE KEY UPDATE ALL VALUES?

问题描述

在重复的键之后，是否有任何简便的方法来更新所有值?例如:

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?

该表有大约50列，而更新每列都会很痛苦.有什么想法吗?

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

推荐答案

您可以为此目的使用REPLACE INTO:

REPLACE INTO published_books SELECT * from books;

这篇关于MySQL的:在重复键更新所有值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！