mysql批量更新数据库

UPDATE users
SET status = CASE id
    WHEN 1 THEN 'active'
    WHEN 2 THEN 'inactive'
    WHEN 3 THEN 'pending'
    -- 添加更多需要更新的记录
END
WHERE id IN (1, 2, 3); -- 指定需要更新的记录ID

DELIMITER //

CREATE PROCEDURE BatchUpdateUsers()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE userId INT;
    DECLARE userStatus VARCHAR(20);
    DECLARE cur CURSOR FOR SELECT id, status FROM temp_users;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO userId, userStatus;
        IF done THEN
            LEAVE read_loop;
        END IF;

        UPDATE users
        SET status = userStatus
        WHERE id = userId;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;

CALL BatchUpdateUsers();