mysql格式转office

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

import pandas as pd
import pymysql

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

# 查询数据
sql = "SELECT * FROM table_name"
df = pd.read_sql(sql, conn)

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

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

pip install python-docx

import pymysql
from docx import Document

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

# 查询数据
sql = "SELECT * FROM table_name"
cursor = conn.cursor()
cursor.execute(sql)
data = cursor.fetchall()

# 创建Word文档
doc = Document()
table = doc.add_table(rows=1, cols=len(data[0]))
table.style = 'Table Grid'

# 添加表头
for i, column in enumerate(data[0]):
    table.cell(0, i).text = column

# 添加数据
for row in data:
    table.add_row(row)

# 保存Word文档
doc.save('output.docx')

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