使用python获取特定列数据的SQL查询

import pymysql

# 或者
import psycopg2

# MySQL连接示例
conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')

# PostgreSQL连接示例
conn = psycopg2.connect(host='localhost', user='username', password='password', database='database_name')

cursor = conn.cursor()

sql = "SELECT column1, column2 FROM table_name"

cursor.execute(sql)

results = cursor.fetchall()

for row in results:
    column1_data = row[0]  # 第一列数据
    column2_data = row[1]  # 第二列数据
    print(column1_data, column2_data)

cursor.close()
conn.close()