mysql查询某一个列的数据

SELECT column_name FROM table_name;

import pymysql

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

try:
    # 构造查询语句
    sql = "SELECT column_name FROM table_name"

    # 执行查询
    with connection.cursor() as cursor:
        cursor.execute(sql)
        result = cursor.fetchall()

    # 处理结果
    for row in result:
        print(row['column_name'])

finally:
    # 关闭数据库连接
    connection.close()