我不理解Y的ValueError。我用%...转义...table=town+"_history"db.execute("SELECTDATE_FORMAT(snapdate,'%%Y-%%m-%%d')ASdate,SUM(population)ASaccountpopulation,count(blockid)ASnumber_blockFROM%sWHEREblockid=%%sGROUPBYsnapdateORDERBYsnapdateDESCLIMIT7"%table,(blockid)) 最佳答案 您将%%转义，然后将字

我不理解Y的ValueError。我用%...转义...table=town+"_history"db.execute("SELECTDATE_FORMAT(snapdate,'%%Y-%%m-%%d')ASdate,SUM(population)ASaccountpopulation,count(blockid)ASnumber_blockFROM%sWHEREblockid=%%sGROUPBYsnapdateORDERBYsnapdateDESCLIMIT7"%table,(blockid)) 最佳答案 您将%%转义，然后将字