pymysql执行有参数的in语句

import pymysql pymysql.install_as_MySQLdb() import pandas as pd  # Mysql数据库连接信息 Mysql_Host = '1**.**.***.***' Mysql_Port = 8066 Mysql_User = 'user' Mysql_Password = '2019' Mysql_Db = 'aib' Mysql_Charset = 'utf8'  conn = pymysql.connect(host=Mysql_Host,                        port=Mysql_Port,                        user=Mysql_User,                        passwd=Mysql_Password,                        db=Mysql_Db,                        charset=Mysql_Charset) cursor = conn.cursor()  set_id = pd.DataFrame([[91069, 2], [91070, 5], [91071, 8]], columns=['A', 'B']) set_id = set_id["A"].tolist()  print(set_id) print(type(set_id))  select_sql = "select filter_data_id,SHEET_ID from filter_data where filter_data_id in %s "  cursor.execute(select_sql, (set_id,))   # 用元组包裹列表，逗号不能少 conn.commit() data = cursor.fetchall() print(data) cursor.close() 

参考：pymysql查询语句中带有in时传递参数的问题