原先的代码段:
sql = """
select province.sum(confirm_now) from details
where update_time=(select update_time from details
order by update_time desc limit 1)
group by province
"""
在网上搜了好久,都说是因为像sum()这类函数前面不能添加空格,但我本身就没什么空格。
所以我一遍遍对比代码,结果发现province.sum()中间不应该是句号,而应该是“逗号”!
正确代码:
sql = """
select province,sum(confirm_now) from details
where update_time=(select update_time from details
order by update_time desc limit 1)
group by province
"""
找到这个错误的我,想死的心都有了……