mysql查询所有表字段

SELECT 
    TABLE_SCHEMA,  -- 数据库名称
    TABLE_NAME,    -- 表名称
    COLUMN_NAME,   -- 字段名称
    DATA_TYPE,     -- 字段数据类型
    COLUMN_KEY     -- 字段键（如主键）
FROM 
    INFORMATION_SCHEMA.COLUMNS
WHERE 
    TABLE_SCHEMA = 'your_database_name';  -- 替换为你的数据库名称

import pymysql

# 连接数据库
connection = pymysql.connect(host='localhost',
                             user='your_username',
                             password='your_password',
                             db='your_database_name',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # 执行SQL查询
        sql = """
        SELECT 
            TABLE_SCHEMA,
            TABLE_NAME,
            COLUMN_NAME,
            DATA_TYPE,
            COLUMN_KEY
        FROM 
            INFORMATION_SCHEMA.COLUMNS
        WHERE 
            TABLE_SCHEMA = %s;
        """
        cursor.execute(sql, ('your_database_name',))
        result = cursor.fetchall()
        print(result)
finally:
    connection.close()