python - 无法使用列表格式化字符串

Question

我有这两个字段

s = "SELECT * FROM %s WHERE %s = %s ORDER BY %s;"
data = ['students', 'age', 12, 'desc']

据我所知，我在列表中计算了足够的元素来格式化字符串。但是

print s.format(data)
#or
print s % tuple(data)
#or
print s % data

返回类型错误:格式字符串参数不足

Answer 1

只需将列表转换为元组，就像这样

s, l = "SELECT * FROM %s WHERE %s = %s ORDER BY %s;",['students','age',12,'desc']
print s % tuple(l)
# SELECT * FROM students WHERE age = 12 ORDER BY desc;

Online Demo