This method sends the COMMIT statement to the MySQL server, committing the current transaction. Since by default, Connector/Python does not autocommit, it is important to call this method after every transaction which updates data for tables using transactional storage engines.

See the rollback() method for rolling back transactions.

>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s)", ('Jane'))
>>> cnx.commit()