mysql-python3中sql传入元组
2019-06-21 本文已影响0人
哪个鹿
import pymysql
mysql_conn = pymysql.connect(host='127.0.0.1', user='root', password='mysql', db='test')
mysql_conn.autocommit(False)
cur1 = mysql_conn.cursor()
his_list = ["a","b","c","d","e","f","g","h"]
args = ','.join(['%s']*len(his_list))
sql = """DELETE FROM test WHERE test_i IN (%s) """ % (args)
print(sql)
cur1.execute(sql, his_list)
