将多行SQL文本文件读入并执行Python程序

with open('sql_file.txt', 'r') as file:
    sql_statements = file.readlines()

import pymysql

# 连接到数据库
connection = pymysql.connect(host='localhost', user='username', password='password', database='database_name')

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

# 执行SQL语句
for sql in sql_statements:
    cursor.execute(sql)

# 提交事务
connection.commit()

# 关闭游标和连接
cursor.close()
connection.close()

pip install pymysql

# 执行带有参数的SQL语句
sql = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
values = ('value1', 'value2')
cursor.execute(sql, values)