在不知道表的列名的情况下遍历表

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', database='your_database')
cursor = conn.cursor()

# 获取表的列信息
table_name = 'your_table'
cursor.execute(f"SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = '{table_name}'")
columns = [column[0] for column in cursor.fetchall()]

# 动态生成查询语句
query = f"SELECT * FROM {table_name} WHERE 1=1"
for column in columns:
    query += f" AND {column} = 'your_condition'"

# 执行查询语句
cursor.execute(query)

# 处理查询结果
for row in cursor.fetchall():
    print(row)

# 关闭数据库连接
cursor.close()
conn.close()