sql 语句使用和转换json数据

import pymysql
import concurrent
coon=pymysql.connect(host='localhost',user='root',password='123456',db='worlflow',charset='utf8',port=3306)
cursor=coon.cursor()
sql="insert into worker (worker_img) values('%s') where id=10"%str(encodesstr,'utf-8')
cursor.execute(sql)
coon.commit()
cursor.close()# 尽量关闭影响性能
coon.close() #

import pymysql
import concurrent

def dictfetchall(cursor):
desc=cursor.description
return [
dict(zip([col[0] for col in desc],row))
for row in cursor.fetchall()
]
def get_access(sql):
cursor=connection.cursor()
cursor.execute(sql)
# result=cursor.fetchall()
result=dictfetchall(cursor)
# print(result)
return result