python 把mysql表转成dict_使用python dict更新MySQL中的表

[2018-03-2506:08:39,972]ERRORinapp:Exceptionon/update[POST]Traceback(most recent calllast):File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\cursors.py",line238,inexecutequery=query%argsTypeError:notall arguments converted duringstringformattingDuringhandlingofthe above exception,another exception occurred:Traceback(most recent calllast):File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\flask\app.py",line1982,inwsgi_appresponse=self.full_dispatch_request()File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\flask\app.py",line1614,infull_dispatch_requestrv=self.handle_user_exception(e)File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\flask\app.py",line1517,inhandle_user_exceptionreraise(exc_type,exc_value,tb)File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\flask\_compat.py",line33,inreraiseraisevalueFile"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\flask\app.py",line1612,infull_dispatch_requestrv=self.dispatch_request()File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\flask\app.py",line1598,indispatch_requestreturnself.view_functions[rule.endpoint](**req.view_args)File"FlaskApp.py",line154,incartUpdatecur.execute(sql,[cart.values()])File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\cursors.py",line240,inexecuteself.errorhandler(self,ProgrammingError,str(m))File"C:\Users\Colin Roberts\AppData\Local\Programs\Python\Python36-32\lib\site-packages\MySQLdb\connections.py",line52,indefaulterrorhandlerraiseerrorclass(errorvalue)_mysql_exceptions.ProgrammingError:notall arguments converted duringstringformatting