如何从fetchall的结果集中删除数组

import pymysql

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

# 执行查询
cursor.execute("SELECT * FROM table_name")
result = cursor.fetchall()

# 创建空数组
to_delete = []

# 遍历结果集
for row in result:
    # 判断是否需要删除该行
    if row[0] == 'value_to_delete':
        # 将需要删除的元素添加到数组中
        to_delete.append(row[0])

# 遍历需要删除的元素
for item in to_delete:
    # 执行删除操作
    cursor.execute("DELETE FROM table_name WHERE column_name = %s", (item,))

# 提交更改
conn.commit()

# 关闭连接
cursor.close()
conn.close()