ON DUPLICATE KEY UPDATE用法

INSERT INTO `books ` (`name`,`count`,`num`) VALUES ('windows','1','2'),('','linux','1','3') ON DUPLICATE KEY UPDATE `count` = `count` + VALUES(`COUNT`), `num`=`num`+VALUES(`num`);
原文地址:https://www.cnblogs.com/zlingh/p/4058439.html