如何将MySQL查询结果导出为多个`txt`文件？

import mysql.connector
import os

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 执行查询
query = "SELECT * FROM yourtable"
cursor.execute(query)

# 获取查询结果
results = cursor.fetchall()

# 将结果导出为多个txt文件
batch_size = 1000  # 每个文件包含的记录数
file_count = 1
batch = []

for row in results:
    batch.append(row)
    if len(batch) >= batch_size:
        with open(f"output_{file_count}.txt", "w") as file:
            for record in batch:
                file.write("\t".join(str(item) for item in record) + "\n")
        batch = []
        file_count += 1

# 处理剩余的记录
if batch:
    with open(f"output_{file_count}.txt", "w") as file:
        for record in batch:
            file.write("\t".join(str(item) for item in record) + "\n")

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

with open(f"output_{file_count}.txt", "w", encoding="utf-8") as file:
    for record in batch:
        file.write("\t".join(str(item) for item in record) + "\n")

batch_size = 5000  # 增加每个文件包含的记录数

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)