mysql导出表结构到word

import pandas as pd
from docx import Document

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

# 查询表结构
cursor = mydb.cursor()
cursor.execute("DESCRIBE table_name")
result = cursor.fetchall()

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

# 填充表头
headers = [i[0] for i in result[0]]
for i, header in enumerate(headers):
    table.cell(0, i).text = header

# 填充数据
for row_idx, row_data in enumerate(result):
    for col_idx, col_data in enumerate(row_data):
        table.cell(row_idx + 1, col_idx).text = str(col_data)

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