mysql输出到excel文件

import pandas as pd
import mysql.connector

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

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

# 获取查询结果
myresult = mycursor.fetchall()

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

# 将DataFrame导出为Excel文件
df.to_excel('output.xlsx', index=False)

import mysql.connector
from openpyxl import Workbook

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

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

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

# 将查询结果写入Excel文件
for row in mycursor:
    ws.append(row)

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