SQL更新列数据，如果UNIQUE约束的key有重复的，则执行更新，否则插入一条新的

INSERT_UPDATE.sql

INSERT INTO test_tong VALUES
("aaa", 9), ("asdf", 9), ("bbb", 9)
ON DUPLICATE KEY UPDATE
score = VALUES(score)


UPDATE test_tong SET
score = CASE tongname
WHEN "aaa" THEN 1
WHEN "asdf" THEN 2
WHEN "bbb" THEN 3
END
WHERE tongname IN("aaa", "asdf", "bbb")