MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (ID INT CHECK (id < 100));
CREATE TABLE table2 LIKE table1;
CREATE TABLE table3 LIKE table1;
CREATE PROCEDURE usp_do_something (
    IN param1 INT,
    IN param2 INT,
    IN param3 INT
)
MODIFIES SQL DATA
BEGIN
    START TRANSACTION;

    INSERT `table1` ( `ID` ) VALUES (param1);
    INSERT `table2` ( `ID` ) VALUES (param2);
    INSERT `table3` ( `ID` ) VALUES (param3);

    COMMIT;
END;
CALL usp_do_something (10, 20, 30);
SELECT *, '1' tablenum FROM table1 UNION ALL
SELECT *, '2' tablenum FROM table2 UNION ALL
SELECT *, '3' tablenum FROM table3 ORDER BY ID;


ID
tablenum


10
1

20
2

30
3


CALL usp_do_something (40, 500, 60);

Check constraint 'table2_chk_1' is violated.


SELECT *, '1' tablenum FROM table1 UNION ALL
SELECT *, '2' tablenum FROM table2 UNION ALL
SELECT *, '3' tablenum FROM table3 ORDER BY ID;


ID
tablenum


10
1

20
2

30
3

40
1


CALL usp_do_something (70, 800, 90);

Check constraint 'table2_chk_1' is violated.


SELECT *, '1' tablenum FROM table1 UNION ALL
SELECT *, '2' tablenum FROM table2 UNION ALL
SELECT *, '3' tablenum FROM table3 ORDER BY ID;

ROLLBACK;

SELECT *, '1' tablenum FROM table1 UNION ALL
SELECT *, '2' tablenum FROM table2 UNION ALL
SELECT *, '3' tablenum FROM table3 ORDER BY ID;


ID
tablenum


10
1

20
2

30
3

40
1

70
1




ID
tablenum


10
1

20
2

30
3

40
1