INSERT INTO tt(id,age) VALUES (48,1),(50,2),(69,2) ON DUPLICATE KEY UPDATE age=VALUES(age);--该片段来自于http://www.codesnippet.cn/detail/0211201513930.html
来源: http://www.codesnippet.cn/detail/0211201513930.html