INSERT INTO statistics(classify, country, ads, year)
VALUES (:classify, :country, 1, :year)
ON DUPLICATE KEY UPDATE ads = ads + 1
INSERT INTO statistics(classify, country, ads,
阅读背景：
当3列的值匹配时，ON DUPLICATE KEY更新
来源：互联网
分享到：
