mysql 修改多个表字段的数据

-- 修改 users 表中的 age 和 status 字段
UPDATE users
SET age = 30, status = 'active'
WHERE id = 1;

-- 修改 users 表中的 age 字段，并修改 orders 表中的 status 字段
START TRANSACTION;

UPDATE users
SET age = 30
WHERE id = 1;

UPDATE orders
SET status = 'completed'
WHERE user_id = 1;

COMMIT;

START TRANSACTION;

UPDATE users
SET age = 30
WHERE id = 1;

UPDATE orders
SET status = 'completed'
WHERE user_id = 1;

COMMIT; -- 提交事务

START TRANSACTION;

UPDATE users
SET age = 30
WHERE id = 1;

UPDATE orders
SET status = 'completed'
WHERE user_id = 1;

-- 如果发生错误，回滚事务
ROLLBACK;

-- 分批处理示例
SET @batch_size = 1000;
SET @offset = 0;

WHILE @offset < (SELECT COUNT(*) FROM users) DO
    UPDATE users
    SET age = 30, status = 'active'
    WHERE id BETWEEN @offset AND (@offset + @batch_size - 1);

    SET @offset = @offset + @batch_size;
END WHILE;