mysql如何导出所有的数据库表字段

SELECT 
    TABLE_SCHEMA, 
    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

def get_table_columns(host, user, password, database):
    conn = mysql.connector.connect(host=host, user=user, password=password, database=database)
    cursor = conn.cursor(dictionary=True)
    
    cursor.execute("SHOW TABLES")
    tables = cursor.fetchall()
    
    for table in tables:
        table_name = table['Tables_in_' + database]
        cursor.execute(f"DESCRIBE {table_name}")
        columns = cursor.fetchall()
        print(f"Table: {table_name}")
        for col in columns:
            print(col)
    
    cursor.close()
    conn.close()

# 使用示例
get_table_columns('localhost', 'your_username', 'your_password', 'your_database_name')