mysql怎么生成数据字典

SELECT 
    TABLE_SCHEMA AS 'Database',
    TABLE_NAME AS 'Table',
    COLUMN_NAME AS 'Column',
    DATA_TYPE AS 'Type',
    IS_NULLABLE AS 'Null',
    COLUMN_DEFAULT AS 'Default'
FROM 
    INFORMATION_SCHEMA.COLUMNS
ORDER BY 
    TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;

import mysql.connector

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

cursor = db.cursor()

# 查询表和列的信息
cursor.execute("""
SELECT 
    TABLE_SCHEMA AS 'Database',
    TABLE_NAME AS 'Table',
    COLUMN_NAME AS 'Column',
    DATA_TYPE AS 'Type',
    IS_NULLABLE AS 'Null',
    COLUMN_DEFAULT AS 'Default'
FROM 
    INFORMATION_SCHEMA.COLUMNS
ORDER BY 
    TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
""")

# 打印结果
for row in cursor.fetchall():
    print(row)

cursor.close()
db.close()