pip install mysql-connector-python
python
import mysql.connector
from mysql.connector import Error
python
try:
connection = mysql.connector.connect(host='localhost',
database='mydb',
user='root',
password='password')
python
connection.autocommit = False
python
cursor = connection.cursor()
python
try:
cursor.execute("START TRANSACTION")
connection.commit()
except Error as e:
connection.rollback()
finally:
cursor.close()
connection.close()
