使用Python为MySQL转储导入执行多个命令

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(
        host='localhost',
        database='your_database',
        user='your_username',
        password='your_password'
    )
    if connection.is_connected():
        print('成功连接到MySQL数据库')
except Error as e:
    print(f'连接失败：{e}')

cursor = connection.cursor()

sql_commands = [
    "CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255))",
    "INSERT INTO customers (name, email) VALUES ('John Doe', 'john@example.com')",
    "INSERT INTO customers (name, email) VALUES ('Jane Smith', 'jane@example.com')"
]

for command in sql_commands:
    try:
        cursor.execute(command)
        connection.commit()
        print(f'成功执行SQL命令：{command}')
    except Error as e:
        print(f'执行SQL命令时出错：{e}')

cursor.close()
connection.close()