def Add(): Customer_id = e1.get() Last_name = e2.get() First_name = e3.get() Middle_initial = e4.get() Street = e5.get() City = e6.get() State = e7.get() Zip = e8.get() Phone = e9.get() Email = e10.get() mysqldb=mysql.connector.connect(host="localhost",user="root",password="",database="bankaccounts") mycursor=mysqldb.cursor() try: sql = "INSERT INTO `customer` (`Customer_id`, `Last_name`, `First_name`, `Middle_initial`, `Street`, `City`, `State`, `Zip`, `Phone`, `Email`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" val = (Customer_id,Last_name,First_name,Middle_initial,Street,City,State,Zip,Phone,Email) '''https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html''' mycursor.execute(sql, val) '''https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html''' mysqldb.commit() lastid = mycursor.lastrowid messagebox.showinfo("information", "Customer inserted successfully...") e1.delete(0, END) e2.delete(0, END) e3.delete(0, END) e4.delete(0, END) e5.delete(0, END) e6.delete(0, END) e7.delete(0, END) e8.delete(0, END) e9.delete(0, END) e10.delete(0, END) e1.focus_set()