python mysql 多id 变量 数据查询

#excel读取需要查询的id 转为tuple格式
id_name = pd.read_csv('ids.csv')
print(id_name)
id_names = id_name.loc[:,'id'].tolist()
id_names = tuple(id_names)
print(id_names)

import pymysql #引入pymssql模块
import pandas as pd

def conn():
    connect = pymysql.connect(host='rr-wz9kfqo60ib73xx28go.mysql.rds.aliyuncs.com', user='developer', passwd="I9q1LRNIPC7Prxjl", db='btclass') #服务器名,账户,密码,数据库名
    if connect:
        print("连接成功!")
    return connect

connect = pymysql.connect(host='rr-wz9kfqo60ib73xx28go.mysql.rds.aliyuncs.com', user='developer', passwd="I9q1LRNIPC7Prxjl", db='btclass') #服务器名,账户,密码,数据库名
if connect:
    print("连接成功!")

cursor = connect.cursor()  # 创建一个游标对象,python里的sql语句都要通过cursor来执行
sql = '''
select wu.openID,o.userId,o.sn, o.title, o.createdTime, from_unixtime(o.paidTime) as 支付时间, o.pa