mysql 批量update 更新 部分字段

1 方式一

UPDATE task
SET is_first = CASE id
WHEN 33 THEN 0
WHEN 41 THEN 0
WHEN 67 THEN 1
END,
pre = CASE id
WHEN 33 THEN 67
WHEN 41 THEN 40
WHEN 67 THEN null
END,
next = CASE id
WHEN 33 THEN 34
WHEN 41 THEN null
WHEN 67 THEN 33
END
WHERE id IN (33,41,67)

2.方式二

INSERT INTO task (id, is_first, pre , next) VALUES
(33,1,null,34 ),
(41,0,40,67 ),
(67,0,41,null)
ON DUPLICATE KEY UPDATE is_first=VALUES(is_first), pre=VALUES(pre), next=VALUES(next);

3.方式三

开启事务进行逐条update处理
最后commit即可