mysql表结构导出word

SHOW CREATE TABLE your_table_name;

import mysql.connector
from docx import Document

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="your_host",
    user="your_user",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 获取所有表名
cursor.execute("SHOW TABLES")
tables = cursor.fetchall()

# 创建Word文档
doc = Document()

for table in tables:
    table_name = table[0]
    cursor.execute(f"SHOW CREATE TABLE {table_name}")
    create_table_sql = cursor.fetchone()[1]
    
    # 添加表结构到Word文档
    doc.add_heading(table_name, level=1)
    doc.add_paragraph(create_table_sql, style='Code')

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

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