如果存在这样的查询 DELETE FROM operations_history op_his WHERE operation_id IN ("64a5e7b2-8098-11e6-a1ab-fa163ef5a45d","aaaaaaaaaaaaaaaaaaaaaa"); 在 MySQLdb 如何写?正确的写法为
his_list = ["64a5e7b2-8098-11e6-a1ab-fa163ef5a45d","aaaaaaaaaaaaaaaaaaaaaa"]
args = ','.join(['%s']*len(his_list))
sql = """DELETE FROM operations_history WHERE operation_id IN (%s) """ % (args)
db_ins.data_operate(sql,his_list) #封装的数据库操作函数。
参考:
https://blog.xupeng.me/2013/09/25/mysqldb-args-processing/