MySQL批量更新

REPLACE INTO users(id,username,birthday,sex,address) VALUES(25,'tom','2011-11-11',2,'杭州'),(26,'李四','2010-10-10',1,'石家庄');
INSERT INTO users(id,username,birthday,sex,address) VALUES(25,'tom','2011-11-11',2,'杭州1'),(26,'李四','2010-10-10',1,'石家庄1') ON
DUPLICATE KEY UPDATE username=VALUES(username),birthday=VALUES(birthday),sex=VALUES(sex),address=VALUES(address)

转载于:https://www.cnblogs.com/annofyf/p/9948049.html