如何将一个表中的XML提取的字段插入到另一个表中？

import xml.etree.ElementTree as ET
import mysql.connector

# 解析XML字段
xml_data = '<data><name>John</name><age>30</age></data>'
root = ET.fromstring(xml_data)

# 提取XML字段数据
name = root.find('name').text
age = root.find('age').text

# 插入到另一个表中
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database')
cursor = cnx.cursor()
insert_query = "INSERT INTO target_table (name, age) VALUES (%s, %s)"
cursor.execute(insert_query, (name, age))
cnx.commit()

cursor.close()
cnx.close()