如何在拆分分支中从Python插入到SQL表中

import pymysql

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

# 创建游标对象
cursor = conn.cursor()

# 构造SQL插入语句
table_name = 'your_table_name'
column1 = 'column1_value'
column2 = 'column2_value'
sql = "INSERT INTO {} (column1, column2) VALUES ('{}', '{}')".format(table_name, column1, column2)

try:
    # 执行SQL插入语句
    cursor.execute(sql)
    
    # 提交事务
    conn.commit()
    print("数据插入成功！")
except Exception as e:
    # 发生错误时回滚
    conn.rollback()
    print("数据插入失败：", e)

finally:
    # 关闭游标和数据库连接
    cursor.close()
    conn.close()