python - MySQL 类型错误 : not enough arguments for format string

Question

当我使用日期时间从 Mysql 检索数据时，发生以下错误
类型错误:格式字符串参数不足。这是我写在下面的代码

temp1=datetime.strptime(date1, '%Y-%m-%d')
temp2=datetime.strptime(date2, '%Y-%m-%d')
rows1=exdb.getData("admin", "SELECT count(id) as total_count from client_onboard WHERE (video_datetime BETWEEN '%s' AND '%s');" % (temp1) %(temp2)) 

Answer 1

The answer in this question thread should solve your problem 。

您应该使用.format()。