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
原文地址:https://www.cnblogs.com/cupleo/p/12325067.html