如何用value+rowID替换表格中的所有字段？

import pymysql

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

# 选择要操作的表格
table_name = 'your_table_name'

# 查询表格中的所有字段
select_query = f"SELECT * FROM {table_name}"
cursor.execute(select_query)
results = cursor.fetchall()

# 遍历查询结果
for row in results:
    # 获取rowID
    row_id = row[0]

    # 对每个字段进行处理
    for i in range(1, len(row)):
        field_value = row[i]
        new_value = f"value{row_id}"

        # 更新表格中的字段
        update_query = f"UPDATE {table_name} SET field{i} = '{new_value}' WHERE rowID = {row_id}"
        cursor.execute(update_query)

# 提交更改并关闭连接
conn.commit()
conn.close()