pymysql sql 查询 in list

2023-08-08  本文已影响0人  虚心的锄头 
list_of_ids = ['1', '2']
format_strings = ','.join(['%s'] * len(list_of_ids))
cursor.execute("DELETE FROM foo.bar WHERE baz IN (%s)" % format_strings,
                tuple(list_of_ids))
上一篇 下一篇

猜你喜欢

热点阅读