pymysql执行有参数的in语句

最新推荐文章于 2023-08-04 17:19:55 发布

爱问西瓜爱大树

最新推荐文章于 2023-08-04 17:19:55 发布

阅读量1k

点赞数

分类专栏： python 文章标签： python mysql 数据库

本文链接：https://blog.csdn.net/u011208984/article/details/106574853

版权

python 专栏收录该内容

86 篇文章 7 订阅

订阅专栏

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时传递参数的问题