mysql数据库表导出为excel

import pymysql
import openpyxl

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

# 执行查询语句
sql = "SELECT * FROM table_name"
cursor.execute(sql)
results = cursor.fetchall()

# 创建Excel文件
wb = openpyxl.Workbook()
ws = wb.active

# 写入表头
columns = [desc[0] for desc in cursor.description]
for col_num, column_title in enumerate(columns, 1):
    ws.cell(row=1, column=col_num, value=column_title)

# 写入数据
for row_num, row_data in enumerate(results, 2):
    for col_num, cell_value in enumerate(row_data, 1):
        ws.cell(row=row_num, column=col_num, value=cell_value)

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

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

mysqldump -u username -p database_name table_name --tab=/path/to/output/folder