The world's most popular open source database
MySQL Connector/Python Developer Guide :: 9 Connector/Python API Reference :: 9.2 Class connection.MySQLConnection :: 9.2.35 Property MySQLConnection.autocommit
Section Navigation [Toggle]
- 9.2 Class connection.MySQLConnection
- 9.2.1 Constructor connection.MySQLConnection(**kwargs)
- 9.2.2 Method MySQLConnection.close()
- 9.2.3 Method MySQLConnection.commit()
- 9.2.4 Method MySQLConnection.config(**kwargs)
- 9.2.5 Method MySQLConnection.connect()
- 9.2.6 Method MySQLConnection.cursor()
- 9.2.7 Method MySQLConnection.cmd_change_user(username='', password='', database='', charset=33)
- 9.2.8 Method MySQLConnection.cmd_debug()
- 9.2.9 Method MySQLConnection.cmd_init_db(database)
- 9.2.10 Method MySQLConnection.cmd_ping()
- 9.2.11 Method MySQLConnection.cmd_process_info()
- 9.2.12 Method MySQLConnection.cmd_process_kill(mysql_pid)
- 9.2.13 Method MySQLConnection.cmd_query(statement)
- 9.2.14 Method MySQLConnection.cmd_query_iter(statement)
- 9.2.15 Method MySQLConnection.cmd_quit()
- 9.2.16 Method MySQLConnection.cmd_refresh(options)
- 9.2.17 Method MySQLConnection.cmd_reset_connection()
- 9.2.18 Method MySQLConnection.cmd_shutdown()
- 9.2.19 Method MySQLConnection.cmd_statistics()
- 9.2.20 Method MySQLConnection.disconnect()
- 9.2.21 Method MySQLConnection.get_row()
- 9.2.22 Method MySQLConnection.get_rows(count=None)
- 9.2.23 Method MySQLConnection.get_server_info()
- 9.2.24 Method MySQLConnection.get_server_version()
- 9.2.25 Method MySQLConnection.is_connected()
- 9.2.26 Method MySQLConnection.isset_client_flag(flag)
- 9.2.27 Method MySQLConnection.ping(attempts=1, delay=0)
- 9.2.28 Method MySQLConnection.reconnect(attempts=1, delay=0)
- 9.2.29 Method MySQLConnection.reset_session()
- 9.2.30 Method MySQLConnection.rollback()
- 9.2.31 Method MySQLConnection.set_charset_collation(charset=None, collation=None)
- 9.2.32 Method MySQLConnection.set_client_flags(flags)
- 9.2.33 Method MySQLConnection.shutdown()
- 9.2.34 Method MySQLConnection.start_transaction()
- 9.2.35 Property MySQLConnection.autocommit
- 9.2.36 Property MySQLConnection.charset_name
- 9.2.37 Property MySQLConnection.collation_name
- 9.2.38 Property MySQLConnection.connection_id
- 9.2.39 Property MySQLConnection.database
- 9.2.40 Property MySQLConnection.get_warnings
- 9.2.41 Property MySQLConnection.in_transaction
- 9.2.42 Property MySQLConnection.raise_on_warnings
- 9.2.43 Property MySQLConnection.server_host
- 9.2.44 Property MySQLConnection.server_port
- 9.2.45 Property MySQLConnection.sql_mode
- 9.2.46 Property MySQLConnection.time_zone
- 9.2.47 Property MySQLConnection.unix_socket
- 9.2.48 Property MySQLConnection.user
This property can be assigned a value of True
or False to enable or disable the autocommit
feature of MySQL. The property can be invoked to retrieve the
current autocommit setting.
Note that autocommit is disabled by default when connecting
through Connector/Python. This can be enabled using the
autocommit
connection
parameter.
When the autocommit is turned off, you must
commit
transactions when using transactional storage engines such as
InnoDB or NDBCluster.
>>> cnx.autocommit False >>> cnx.autocommit = True >>> cnx.autocommit True
User Comments