where in 查询是很常见的，但你知道 python3 中怎么写吗？
话不多说直接上 sample
import pymysql
import config
sql = """
SELECT
abc,
MAX(last_updated) as last_updated
FROM
xxx
WHERE
abc IN ({})
"""
class Runner(object):
...
def phone_exist(self, abc):
sai = []
placeholders = ", ".join(["%s"] * len(abc))
query = trovo_sql.format(placeholders)
self.cursor.execute(query, abc)
rows = self.cursor.fetchall()
for row in rows:
sai.append(row["abc"])
return sai
return sai
|
