MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t1 (x int NOT NULL);
CREATE TABLE t2 (y int NOT NULL);
CREATE TABLE t3 (z int NOT NULL);

INSERT INTO t1 (x) VALUES (1);
INSERT INTO t2 (y) VALUES (2);
INSERT INTO t3 (z) VALUES (3);
CREATE PROCEDURE proc1()
BEGIN
    SELECT 1;
    UPDATE t1 SET x = x + 1;
    SELECT 11;
END
CREATE PROCEDURE proc2()
BEGIN
    SELECT 2;
    UPDATE t2 SET y = y - 1;
    SELECT 22;
END
CREATE PROCEDURE proc3()
BEGIN
    SELECT 3;
    UPDATE t3 SET z = z / 0;
    SELECT 33;
END
CREATE PROCEDURE call_procs()
BEGIN
    /* declare an exit handler, which is similar to the CATCH in a TRY...CATCH */
    DECLARE exit handler for SQLEXCEPTION
    BEGIN
        GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE, 
            @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;
        SET @full_error = CONCAT("ERROR ", COALESCE(@errno, ""), " (", COALESCE(@sqlstate, ""), "): ", COALESCE(@text, ""));
        ROLLBACK;
        SELECT @full_error;
    END;
    
    SET autocommit = 0;
    START TRANSACTION;
    CALL proc1();
    CALL proc2();
    CALL proc3();
END
CALL call_procs();

1

1

11

11

2

2

22

22

3

3

@full_error

ERROR 1365 (22012): Division by 0

SELECT *
FROM t1;

SELECT *
FROM t2;

SELECT *
FROM t3;

x

1

y

2

z

3