在事务中执行之前准备多个语句？

BEGIN;
INSERT INTO users (name, age) VALUES ('John Doe', 30);
INSERT INTO user_profiles (user_id, email) VALUES (LAST_INSERT_ID(), 'john.doe@example.com');
COMMIT;

import mysql.connector

cnx = mysql.connector.connect(user='user', password='password', host='localhost', database='database')
cursor = cnx.cursor()

try:
    cursor.execute("BEGIN")
    add_user = ("INSERT INTO users (name, age) VALUES (%s, %s)")
    user_data = ('John Doe', 30)
    cursor.execute(add_user, user_data)

    add_profile = ("INSERT INTO user_profiles (user_id, email) VALUES (LAST_INSERT_ID(), %s)")
    profile_data = ('john.doe@example.com',)
    cursor.execute(add_profile, profile_data)

    cursor.execute("COMMIT")
except Exception as e:
    cursor.execute("ROLLBACK")
    print("Error: ", e)
finally:
    cursor.close()
    cnx.close()