比如一个常见的操作:
SELECT * FROM my_table
WHERE name in ("小明","小红","小蓝")
但是在python中,给定一个列表
filter_list = ["小A","小B","小C","小D"]
那么通过给定的列表filter_list,构造完成的sql语句,交给程序执行的方法如下:
my_list = ["小A", "小B", "小C"]
new_string = "\",\"".join(my_list)
my_sql = """SELECT * FROM my_table WHERE name in ("{}");""".format(new_string)
print(my_sql)
得到结果:
SELECT * FROM my_table WHERE name in ("小A","小B","小C");