根据 case when then 批量更新多个字段

UPDATE test
SET

type = CASE id
WHEN 5 THEN 32
WHEN 7 THEN 42
END,
isRequired = CASE id
WHEN 5 THEN 52
WHEN 7 THEN 62
END,
minLen = CASE id
WHEN 5 THEN 91
WHEN 7 THEN 92
END,
maxLen = CASE id
WHEN 5 THEN 93
WHEN 7 THEN 94
END
WHERE id IN (5,7)