I have a database named accounts_1 amd a table in it named myrecords, this is that database and i want to delete a particular record as user inputs in the variable Email, Website and Password. I have a code below, it shows no error and also the message Record deleted but nothing is deleted in my mysql database, even i already used commit() but still noting is commited. Please help me out of this.
删除功能如下:
def delrec():
newroot=Toplevel()
def record():
Email = email.get()
Password = passwd.get()
Website = website.get()
delete="delete from myrecords where Website='%s' and Email='%s' and Password='%s'" %(Website,Email,Password)
if(Website !="" and Email !="" and Password !=""):
mycursor.execute(delete)
mydb.commit()
messagebox.askokcancel("