如何将所有字段的值从一条记录复制到另一条记录？

import mysql.connector

# 连接到数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')
cursor = cnx.cursor()

# 获取源记录的字段值
query = "SELECT field1, field2, field3 FROM source_table WHERE id = 1"
cursor.execute(query)
result = cursor.fetchone()

# 将字段值保存到变量中
field1_value = result[0]
field2_value = result[1]
field3_value = result[2]

# 将字段值复制到目标记录
insert_query = "INSERT INTO target_table (field1, field2, field3) VALUES (%s, %s, %s)"
data = (field1_value, field2_value, field3_value)
cursor.execute(insert_query, data)

# 提交事务并关闭连接
cnx.commit()
cursor.close()
cnx.close()