MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT VERSION();

VERSION()

8.0.22

PREPARE `stmt` FROM 'SELECT 1';
EXECUTE `stmt`;

PREPARE `stmt` FROM 'SELECT 2';
EXECUTE `stmt`;

DEALLOCATE PREPARE `stmt`;

1

1

2

2

PREPARE `stmt` FROM 'SELECT 1; SELECT 2;';
EXECUTE `stmt`;
DEALLOCATE PREPARE `stmt`;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT 2' at line 1