问使用另一个表中的值更新记录- MySQL (Python)

EN

query = "select*from csms where feedback in('null', 'I expect a better one', 'Bad one! Need one again')"
mycursor.execute(query)
p = mycursor.fetchall()

for i in p:
    query_upserv = """update csms inner join serviceppl on csms.product = serviceppl.speciality
                      set serviceppl.name = csms.serviceman where csms.product = '{}'""".format(i[4])
    mycursor.execute(query_upserv)
    mycon.commit()