Python mysql.connector插入不起作用

import mysql.connector

# 创建数据库连接
cnx = mysql.connector.connect(user='username', password='password', host='hostname', database='database_name')

# 检查连接是否成功
if cnx.is_connected():
    print('成功连接到MySQL数据库')
else:
    print('连接失败')

import mysql.connector

cnx = mysql.connector.connect(user='username', password='password', host='hostname', database='database_name')
cursor = cnx.cursor()

# 检查表是否存在
cursor.execute("SHOW TABLES LIKE 'table_name'")
result = cursor.fetchone()

if result:
    print('表存在')
else:
    print('表不存在')

import mysql.connector

cnx = mysql.connector.connect(user='username', password='password', host='hostname', database='database_name')
cursor = cnx.cursor()

# 插入数据
insert_query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
data = ('value1', 'value2')
cursor.execute(insert_query, data)
cnx.commit()

print('数据插入成功')

import mysql.connector

try:
    cnx = mysql.connector.connect(user='username', password='password', host='hostname', database='database_name')
    cursor = cnx.cursor()

    # 插入数据
    insert_query = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
    data = ('value1', 'value2')
    cursor.execute(insert_query, data)
    cnx.commit()

    print('数据插入成功')

except mysql.connector.Error as error:
    print('插入数据时发生错误：{}'.format(error))

finally:
    if cnx.is_connected():
        cursor.close()
        cnx.close()