mysql如何批量修改

UPDATE your_table
SET column_name = CASE
    WHEN condition1 THEN new_value1
    WHEN condition2 THEN new_value2
    -- 更多条件...
    ELSE default_value
END;

UPDATE users
SET status = CASE
    WHEN age < 18 THEN 'minor'
    WHEN age BETWEEN 18 AND 60 THEN 'adult'
    ELSE 'senior'
END;

INSERT INTO your_table (column1, column2, ...)
VALUES (value1, value2, ...),
       (value3, value4, ...),
       -- 更多值...
ON DUPLICATE KEY UPDATE
    column_name = VALUES(column_name);

INSERT INTO users (id, name, email)
VALUES (1, 'Alice', 'alice@example.com'),
       (2, 'Bob', 'bob@example.com')
ON DUPLICATE KEY UPDATE
    email = VALUES(email);

DELIMITER //

CREATE PROCEDURE BatchUpdateUsers()
BEGIN
    UPDATE users
    SET status = 'inactive'
    WHERE last_login < DATE_SUB(NOW(), INTERVAL 6 MONTH);
END //

DELIMITER ;

CALL BatchUpdateUsers();