mysql输出execl

import pandas as pd
import pymysql

# 连接MySQL数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')
cursor = conn.cursor()

# 执行SQL查询
cursor.execute("SELECT * FROM table_name")
data = cursor.fetchall()

# 将查询结果转换为DataFrame
df = pd.DataFrame(list(data), columns=[i[0] for i in cursor.description])

# 将DataFrame写入Excel文件
df.to_excel('output.xlsx', index=False)

# 关闭连接
cursor.close()
conn.close()

# 在连接数据库时指定字符集
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name', charset='utf8mb4')

from openpyxl import Workbook
import pymysql

# 连接MySQL数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name')
cursor = conn.cursor()

# 创建Excel工作簿和工作表
wb = Workbook()
ws = wb.active

# 分页查询并写入数据
page_size = 1000
offset = 0
while True:
    cursor.execute("SELECT * FROM table_name LIMIT %s OFFSET %s", (page_size, offset))
    data = cursor.fetchall()
    if not data:
        break
    for row in data:
        ws.append(row)
    offset += page_size

# 保存Excel文件
wb.save('output.xlsx')

# 关闭连接
cursor.close()
conn.close()