摘要： DUPLICATE KEY UPDATE batch执行时出死锁错误背景知识一、 mysql insert 与 duplicate key：典型的插入语句：多条：INSERT INTO tablename (columnA, columnB, columnC)VALUES ('a', 1, 2), ('b', 7, 5)单条：INSERT INTO tablename SET columnA='a', columnB=1, columnC=2复制：INSERT [options1] [INTO] tablename [ (columnlist) 阅读全文