mysql查询数据库表中字段的数量

-- 使用DESCRIBE命令
DESCRIBE table_name;

-- 使用SHOW COLUMNS命令
SHOW COLUMNS FROM table_name;

import pymysql

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

try:
    with connection.cursor() as cursor:
        # 执行查询
        sql = "SHOW COLUMNS FROM table_name"
        cursor.execute(sql)
        result = cursor.fetchall()
        # 计算字段数量
        field_count = len(result)
        print(f"表中的字段数量是: {field_count}")
finally:
    connection.close()