使用python执行sql语句,
sql = """
select area,
total_confirm
from area_detail
where date_format(update_time, '%Y-%m-%d')=
(select date_format(Max(update_time), '%Y-%m-%d') as update_time
from area_detail
limit 1)
and area != '湖北'
order by total_confirm desc
limit 10
"""
报错如下:line 140, in mogrify
query = query % self._escape_args(args, conn)
TypeError: not enough arguments for format string
解决方法:将日期格式化转中的%去掉即可