MySQL :: MySQL Connector/Python :: 7.2.5 Method MySQLConnection.commit()

MySQL Connector/Python :: 7 Connector/Python API Reference :: 7.2 Class connection.MySQLConnection :: 7.2.5 Method MySQLConnection.commit()

« 7.2.4 Method MySQLConnection.connect(**kwargs)

7.2.6 Method MySQLConnection.cursor(buffered=None, raw=None, cursor_class=None) »

Section Navigation [Toggle]

7.2 Class connection.MySQLConnection
7.2.1 Constructor connection.MySQLConnection(**kwargs)
7.2.2 Method MySQLConnection.close()
7.2.3 Method MySQLConnection.config(**kwargs)
7.2.4 Method MySQLConnection.connect(**kwargs)
7.2.5 Method MySQLConnection.commit()
7.2.6 Method MySQLConnection.cursor(buffered=None, raw=None, cursor_class=None)
7.2.7 Method MySQLConnection.cmd_change_user(username='', password='', database='', charset=33)
7.2.8 Method MySQLConnection.cmd_debug()
7.2.9 Method MySQLConnection.cmd_init_db(database)
7.2.10 Method MySQLConnection.cmd_ping()
7.2.11 Method MySQLConnection.cmd_process_info()
7.2.12 Method MySQLConnection.cmd_process_kill(mysql_pid)
7.2.13 Method MySQLConnection.cmd_quit()
7.2.14 Method MySQLConnection.cmd_query(statement)
7.2.15 Method MySQLConnection.cmd_query_iter(statement)
7.2.16 Method MySQLConnection.cmd_refresh(options)
7.2.17 Method MySQLConnection.cmd_shutdown()
7.2.18 Method MySQLConnection.cmd_statistics()
7.2.19 Method MySQLConnection.disconnect()
7.2.20 Method MySQLConnection.get_rows(count=None)
7.2.21 Method MySQLConnection.get_row()
7.2.22 Method MySQLConnection.get_server_info()
7.2.23 Method MySQLConnection.get_server_version()
7.2.24 Method MySQLConnection.is_connected()
7.2.25 Method MySQLConnection.isset_client_flag(flag)
7.2.26 Method MySQLConnection.ping(attempts=1, delay=0)
7.2.27 Method MySQLConnection.reconnect(attempts=1, delay=0)
7.2.28 Method MySQLConnection.rollback()
7.2.29 Method MySQLConnection.set_charset_collation(charset=None, collation=None)
7.2.30 Method MySQLConnection.set_client_flags(flags)
7.2.31 Property MySQLConnection.autocommit
7.2.32 Property MySQLConnection.charset_name
7.2.33 Property MySQLConnection.collation_name
7.2.34 Property MySQLConnection.connection_id
7.2.35 Property MySQLConnection.database
7.2.36 Property MySQLConnection.get_warnings
7.2.37 Property MySQLConnection.raise_on_warnings
7.2.38 Property MySQLConnection.server_host
7.2.39 Property MySQLConnection.server_port
7.2.40 Property MySQLConnection.sql_mode
7.2.41 Property MySQLConnection.time_zone
7.2.42 Property MySQLConnection.unix_socket
7.2.43 Property MySQLConnection.user

7.2.5. Method `MySQLConnection.commit()`

This method sends the COMMIT command to the MySQL server, committing the current transaction. Since by default, Connector/Python does not auto commit, 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()

Top / Previous / Next / Up / Table of Contents

7.2.5. Method MySQLConnection.commit()

7.2.5. Method `MySQLConnection.commit()`