从不同的select语句自动创建多个csv并保存在给定路径中

import csv
import pymysql

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

# 执行select语句并保存结果到CSV文件
def execute_select_query(query, file_path):
    cursor = connection.cursor()
    cursor.execute(query)
    result = cursor.fetchall()

    with open(file_path, 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerows(result)

# 定义select语句和对应的文件路径
select_queries = {
    'query1': 'SELECT * FROM table1',
    'query2': 'SELECT * FROM table2',
    'query3': 'SELECT * FROM table3'
}

file_paths = {
    'query1': '/path/to/query1.csv',
    'query2': '/path/to/query2.csv',
    'query3': '/path/to/query3.csv'
}

# 执行select语句并保存结果到CSV文件
for query_name, query in select_queries.items():
    file_path = file_paths[query_name]
    execute_select_query(query, file_path)

# 关闭数据库连接
connection.close()