python list tuple 如何传参 正确使用MySQL where in ()

param = [1,2,3]
#或者
param = [‘1’,‘2’,‘3’]
sql_in =     """
SELECT id,customer_number,customer_name
from customer_info
where id in {}
""".format(tuple(param))

传入时,注意参数内部的数据类型,int 还是str

 

posted @ 2020-02-18 10:24  cup_leo  阅读(1200)  评论(0编辑  收藏  举报