pip install mysql-python
python
import MySQLdb
conn = MySQLdb.connect(host='localhost', user='root', passwd='password', db='test_db')
python
cursor = conn.cursor()
cursor.execute('START TRANSACTION')
try:
cursor.execute('CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(20))')
cursor.execute('INSERT INTO users (name) VALUES ("Alice")')
cursor.execute('INSERT INTO users (name) VALUES ("Bob")')
cursor.execute('INSERT INTO users (name) VALUES ("Charlie")')
cursor.execute('COMMIT')
except:
cursor.execute('ROLLBACK')
python
cursor.close()
conn.close()
