Python Forum

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.

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

(Feb-11-2023, 11:21 AM)ibreeden Wrote: [ -> ]Perhaps you should commit the changes. Add "conn.commit()" after executing the update statement. Does that help?

thank you!