Hi,
I have a problem. My library mysql-connector
my code working but doesnt updating table
I have a problem. My library mysql-connector
my code working but doesnt updating table
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