Mysql Workbench table not updated

[CatBall]

My code:
(I want "pathology" table in MySQL Workbench to be updated when clicking on the "update" button.)

 def update(self):
            conn=mysql.connector.connect(host="localhost",user="root",password="root",database="pathology")
            my_cursor=conn.cursor()       
            my_cursor.execute("update pathology set receivedate=%s,patientname=%s,pathologynum=%s,gender=%s,age=%s,inspechospital=%s,casenum=%s,specimenclass=%s,bed=%s,diagnosis=%s,clinicaldiagnose=%s,inspecdoctor=%s,pathologydoctor=%s,sampledate=%s,reportdate=%s where num=%s",(
                                self.var_rec_date.get(),
                                self.var_patient_name.get(),
                                self.var_path_num.get(),
                                self.var_gender.get(),
                                self.var_age.get(),
                                self.var_sub_hospital.get(),
                                self.var_case_num.get(),
                                self.var_specimen_level.get(),
                                self.var_bed.get(),
                                self.var_diagnosis.get(),
                                str(contents),                                                                         
                                self.var_submit_doctor.get(),
                                self.var_simple_date.get(),
                                self.var_path_doc.get(),
                                self.var_report_date.get(),   
                                self.var_sys_num.get(),                
            ))

My "pathology report", you can see the "update" button.


"Successfully updated"


Here's my "pathology" in MySQL Workbench. The values in the "pathology" table aren't updated.

[ibreeden]

Perhaps you should commit the changes. Add "conn.commit()" after executing the update statement. Does that help?

[CatBall]

Perhaps you should commit the changes. Add "conn.commit()" after executing the update statement. Does that help?

thank you!