mysql 多个语句怎么写

SELECT * FROM table1;
INSERT INTO table2 (column1, column2) VALUES ('value1', 'value2');
UPDATE table3 SET column1 = 'new_value' WHERE condition;

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

mycursor = mydb.cursor()

sql = """
SELECT * FROM table1;
INSERT INTO table2 (column1, column2) VALUES ('value1', 'value2');
UPDATE table3 SET column1 = 'new_value' WHERE condition;
"""

mycursor.execute(sql, multi=True)

mydb.commit()

DELIMITER //

CREATE PROCEDURE MultipleStatements()
BEGIN
    SELECT * FROM table1;
    INSERT INTO table2 (column1, column2) VALUES ('value1', 'value2');
    UPDATE table3 SET column1 = 'new_value' WHERE condition;
END //

DELIMITER ;

CALL MultipleStatements();

START TRANSACTION;

SELECT * FROM table1;
INSERT INTO table2 (column1, column2) VALUES ('value1', 'value2');
UPDATE table3 SET column1 = 'new_value' WHERE condition;

COMMIT;