mysql更新clob 语句_如何更新clob类型的内容

importrequestsimportjsonimportunittestimportHTMLTestRunner#- [x] sqlplus finser/finser2015X@//10.139.39.43:1524/sjw2

importpandas as pdimporttimeimportpymysqlimportcx_Oracle#解决乱码问题

importos

os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'id1=18 #风控id

bianliang = 'ir_m3_cell_x_name_cnt'

#B环境#myydb =cx_Oracle.connect(host = '10.139.39.43',user = 'finser',passwd = 'finser2015X',port=1524,database ='sjw2',charset='utf-8' )#A环境

mydb=cx_Oracle.connect("finser/finser2015X@//223.203.128.4:15331/sjw1")

mycursor=mydb.cursor()#1/5

'''如何更改clob类型的数据，以下可以读取出来，但是更新不成功？？？'''sql= "select t.RESULT_INFO from finser.td_s_cro_account t where t.cro_id = {0} and user_name = '王亮'and user_phonetel='13986671119'".format(id1)

mycursor.execute(sql)

pram=[]for i inmycursor:

text=i[0].read()

pram.append(text)#print('text:',text)#print('pram：',pram)

print('text的类型:',type(text)) #text的类型:

print('pram的类型:',type(pram)) #pram的类型:

dict1= eval(text) #将字符串类型数据转变为字典类型

print('dict1的类型',type(dict1))print('dict1',dict1["data"])

dict2= dict1["data"]print('dict2的数据类型：',type(dict2)) #dict2的数据类型：

print('取出一个变量的值',dict2[bianliang])#mydb.close()#mycursor.close()

#dict2[] = 0

#2/5

sql2 = "Delete from finser.TD_S_CRO_ACCOUNT_HANDLE_RECORD a where a.name = '王亮';"mycursor.execute(sql2)#设置等待n秒后再继续执行后面的程序

time.sleep(2)#3/5

sql3 = "UPDATE finser.cf_loan_release a SET a.status = 50 WHERE a.order_no ='MFJK-SJInTest2021-11-05-05-39-20-1';"mycursor.execute(sql3)#设置等待n秒后再继续执行后面的程序

time.sleep(3)#5/5#查询结果是否命中

sql4 = "select t.REMARK,T.MESSAGE from finser.TD_S_CRO_ACCOUNT_HANDLE_RECORD t where name ='王亮'"mycursor.execute(sql4)

myresult=mycursor.fetchall()#print(myresult)#print(type(myresult)) #

mystr = str(myresult) #list转换为str

if 'Y' inmystr:print('未命中')if 'N' inmystr:print('命中')