使用动态SQL遍历数据库中的多个浮点列

import pymysql

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

# 列名列表
columns = ['column1', 'column2', 'column3']

# 遍历列
for column in columns:
    # 构建SQL语句
    sql = "SELECT {} FROM table_name".format(column)
    
    # 执行SQL语句
    cursor.execute(sql)
    
    # 获取结果
    results = cursor.fetchall()
    
    # 处理结果
    for row in results:
        # 处理每一行数据
        print(row)

# 关闭连接
cursor.close()
conn.close()

import pymysql

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

# 列名列表
columns = ['column1', 'column2', 'column3']

# 遍历列
for column in columns:
    # 构建SQL语句
    sql = "SELECT %s FROM table_name"
    
    # 执行SQL语句
    cursor.execute(sql, column)
    
    # 获取结果
    results = cursor.fetchall()
    
    # 处理结果
    for row in results:
        # 处理每一行数据
        print(row)

# 关闭连接
cursor.close()
conn.close()