python - Python 的 MySQL 查询中字符串参数不足，多个 IN 子句包含列表值

Question

我有下面的代码，一旦我添加第二个 IN 子句来过滤姓氏，它就无法工作。

format_fname = ','.join(['%s'] * len(stFirstnames))
format_lname = ','.join(['%s'] * len(stLastnames))

curDox.execute("SELECT * FROM user WHERE firstname IN (%s) AND lastname IN (%s)" % format_fname,
                tuple(stFirstnames), format_lname,tuple(stLastnames))

我得到的错误是

TypeError: not enough arguments for format string

Answer 1

试试这个:

format_fname = ', '.join(['\'%s\''] * len(stFirstnames))
format_lname = ', '.join(['\'%s\''] * len(stLastnames))

curDox.execute("SELECT * FROM user WHERE firstname IN (%s) AND lastname IN (%s)" % (format_fname % tuple(stFirstnames), (format_lname % tuple(stLastnames))))