Mysql Workbench table not updated - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: General Coding Help (https://python-forum.io/forum-8.html) +--- Thread: Mysql Workbench table not updated (/thread-39394.html) |
Mysql Workbench table not updated - CatBall - Feb-10-2023 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. RE: Mysql Workbench table not updated - ibreeden - Feb-11-2023 Perhaps you should commit the changes. Add "conn.commit()" after executing the update statement. Does that help? RE: Mysql Workbench table not updated - CatBall - Feb-13-2023 (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! |