Steps for Update MySQL tables in Python
MySQLConnectionobject and call the execute() method of the MySQLCursor object.
To accept the changes, you call the
commit() method of the MySQLConnection object after calling the execute() method. Otherwise, no changes will be made
UPDATE Database_Name.Table_Name SET Column1_Name = value1, Column2_Name = value2, ... WHERE condition
Inserting a record into two the "customers" and "employee" table:
record successfully updated.