python mysql 操作查询提示not enough arguments for format string

Question

python mysql 操作查询提示not enough arguments for format string
代码:

sql_insert ="""select * from sj where expect >= %s and expect <= %s;"""
cur.execute(sql_insert,(90))

这是为什么

Answer 1

(90,90)

Answer 2

sql字符串里有两个%s，那么你需要传两个值