如何批量修改mysql 数据

UPDATE users
SET status = CASE id
    WHEN 1 THEN 'active'
    WHEN 2 THEN 'inactive'
    WHEN 3 THEN 'pending'
    -- ... 可以继续添加更多条件
END;

INSERT INTO users (id, name, status)
VALUES (1, 'Alice', 'active'),
       (2, 'Bob', 'inactive'),
       (3, 'Charlie', 'pending')
ON DUPLICATE KEY UPDATE
    name = VALUES(name),
    status = VALUES(status);

CREATE TEMPORARY TABLE temp_users AS
SELECT id, name, status
FROM users
WHERE id IN (1, 2, 3);

UPDATE users
JOIN temp_users ON users.id = temp_users.id
SET users.name = temp_users.name,
    users.status = temp_users.status;

DROP TEMPORARY TABLE temp_users;

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

update_data = [
    {'id': 1, 'status': 'active'},
    {'id': 2, 'status': 'inactive'},
    {'id': 3, 'status': 'pending'},
    # ... 可以添加更多数据
]

for row in update_data:
    sql = "UPDATE users SET status = %s WHERE id = %s"
    cursor.execute(sql, (row['status'], row['id']))

db.commit()
cursor.close()
db.close()