python - Python Mysql 连接器更新工作但不更新表

Question

我的代码工作但不更新表

if passentry != "":
    query=("UPDATE customer SET passw = %s WHERE mail = %s")
    value= (passentry2,mailal)
    mycursor2.execute(query,value)
    veritab.commit()

elif nameentry != "":
    query=("UPDATE customer SET name= %s WHERE mail = %s")
    value= (nameentry2,mailal)
    mycursor2.execute(query,value)
    veritab.commit()

elif surnameentry!= "":
    query=("UPDATE customer SET surname= %s WHERE mail = %s")
    value= (surnameentry2,mailal)
    mycursor2.execute(query,value)
    veritab.commit()

else:
    pass

标签： pythonmysqltkinter