mysql导出关系模型

SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    COLUMN_KEY, 
    EXTRA 
FROM 
    INFORMATION_SCHEMA.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name' 
ORDER BY 
    TABLE_NAME, 
    ORDINAL_POSITION;

import mysql.connector
import json

# 连接到MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database_name"
)

cursor = db.cursor()

# 查询数据库结构
cursor.execute("""
SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    DATA_TYPE, 
    COLUMN_KEY, 
    EXTRA 
FROM 
    INFORMATION_SCHEMA.COLUMNS 
WHERE 
    TABLE_SCHEMA = 'your_database_name'
""")

# 将结果转换为JSON格式
result = []
for row in cursor.fetchall():
    result.append({
        "table_name": row[0],
        "column_name": row[1],
        "data_type": row[2],
        "column_key": row[3],
        "extra": row[4]
    })

# 导出为JSON文件
with open("database_structure.json", "w") as f:
    json.dump(result, f, indent=4)

cursor.close()
db.close()