mysql 执行两条语句怎么写

SELECT * FROM table1; 
UPDATE table2 SET column1 = value1 WHERE condition;

DELIMITER //

CREATE PROCEDURE execute_two_statements()
BEGIN
    SELECT * FROM table1;
    UPDATE table2 SET column1 = value1 WHERE condition;
END //

DELIMITER ;

CALL execute_two_statements();

START TRANSACTION;

SELECT * FROM table1;
UPDATE table2 SET column1 = value1 WHERE condition;

COMMIT;

SELECT * FROM table1
UNION ALL
SELECT * FROM table2 WHERE condition;

PREPARE stmt FROM 'SELECT * FROM table1; UPDATE table2 SET column1 = ? WHERE condition;';
SET @value = 'value1';
EXECUTE stmt USING @value;
DEALLOCATE PREPARE stmt;