python-mysqlHow do I enable autocommit in Python MySQL?

To enable autocommit in Python MySQL, you need to use the autocommit method of the MySQLConnection object. This method takes a boolean value, True to enable autocommit, or False to disable it.

Example code

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword"
)

mycursor = mydb.cursor()

mydb.autocommit = True

Code explanation

1. import mysql.connector - imports the mysql.connector module
2. mydb = mysql.connector.connect(host="localhost", user="yourusername", passwd="yourpassword") - connects to the MySQL database
3. mycursor = mydb.cursor() - creates a cursor object
4. mydb.autocommit = True - enables autocommit

Helpful links

• MySQL Documentation - autocommit
• MySQL Connector/Python Documentation - autocommit

Edit this code on GitHub