如何在处理数据库foreach循环中调用data_array

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='mydb')
cursor = conn.cursor()

# 获取数据集合
sql = "SELECT * FROM mytable"
cursor.execute(sql)
data_array = cursor.fetchall()

# 遍历数据集合
for data in data_array:
    # 获取当前元素的值
    value1 = data[0]
    value2 = data[1]
    
    # 进行进一步的处理
    processed_value = value1 + value2
    
    # 更新数据库
    update_sql = "UPDATE mytable SET processed_value = %s WHERE id = %s"
    cursor.execute(update_sql, (processed_value, data[2]))
    conn.commit()

# 关闭数据库连接
cursor.close()
conn.close()