mysql批量修改多个字段

UPDATE users
SET age = CASE id
    WHEN 1 THEN 25
    WHEN 2 THEN 30
    WHEN 3 THEN 35
END,
email = CASE id
    WHEN 1 THEN 'user1@example.com'
    WHEN 2 THEN 'user2@example.com'
    WHEN 3 THEN 'user3@example.com'
END
WHERE id IN (1, 2, 3);

UPDATE users
SET age = (SELECT new_age FROM update_data WHERE users.id = update_data.id),
email = (SELECT new_email FROM update_data WHERE users.id = update_data.id)
WHERE id IN (SELECT id FROM update_data);

-- 示例：确保子查询返回正确的结果
UPDATE users
SET age = (SELECT new_age FROM update_data WHERE users.id = update_data.id),
email = (SELECT new_email FROM update_data WHERE users.id = update_data.id)
WHERE EXISTS (SELECT 1 FROM update_data WHERE users.id = update_data.id);

-- 示例：分批更新
DO 10 (
    UPDATE users
    SET age = (SELECT new_age FROM update_data WHERE users.id = update_data.id),
    email = (SELECT new_email FROM update_data WHERE users.id = update_data.id)
    WHERE id IN (SELECT id FROM update_data LIMIT 1000)
);