mysql导出数据库字典

SELECT 
    TABLE_SCHEMA AS 'Database', 
    TABLE_NAME AS 'Table', 
    COLUMN_NAME AS 'Column', 
    DATA_TYPE AS 'Data Type', 
    COLUMN_KEY AS 'Key', 
    EXTRA AS 'Extra' 
FROM 
    INFORMATION_SCHEMA.COLUMNS 
ORDER BY 
    TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;

import mysql.connector

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

cursor = db.cursor()

# 执行查询
query = """
SELECT 
    TABLE_SCHEMA AS 'Database', 
    TABLE_NAME AS 'Table', 
    COLUMN_NAME AS 'Column', 
    DATA_TYPE AS 'Data Type', 
    COLUMN_KEY AS 'Key', 
    EXTRA AS 'Extra' 
FROM 
    INFORMATION_SCHEMA.COLUMNS 
ORDER BY 
    TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
"""

cursor.execute(query)

# 导出结果
with open("database_dictionary.txt", "w") as f:
    for row in cursor.fetchall():
        f.write(f"{row[0]}\t{row[1]}\t{row[2]}\t{row[3]}\t{row[4]}\t{row[5]}\n")

cursor.close()
db.close()