Mysql嵌套事务与回滚(Mysql nested transaction with rollback)

 有人可以告诉我是否有可能从一个程序中调用另一个程序，如果任何一个程序的任何部分失败，请回滚所有内容？ 
 
 如果可以，有人可以告诉我一个如何实现这个的小例子吗？ 
 
 编辑：过程“b”失败，但过程“a”仍然在表“a”中插入一行。 我的理解是，如果插入的任何部分失败，那么所有（两个插入）都会回滚，而这里没有发生。 问题是为什么不呢？ 
 
 程序“a” 
 
BEGIN
  DECLARE b INT DEFAULT 0;
  DECLARE EXIT HANDLER FOR SQLWARNING ROLLBACK;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;

  START TRANSACTION;
    INSERT INTO a(a)
    VALUES(iA);

     CALL b(iB,LAST_INSERT_ID(),@b);
     SELECT @b INTO b;

     IF b !=1 THEN
        ROLLBACK;
      ELSE
        COMMIT;
  END IF;
END
 
 程序“b” 
 
BEGIN
  DECLARE b INT DEFAULT 0;
  DECLARE EXIT HANDLER FOR SQLWARNING ROLLBACK;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;

  START TRANSACTION;
    INSERT INTO b VALUES(iB,id);
    SET b=1;
  COMMIT;
END;

Can someone tell me if it is possible to call another procedure from within a procedure and if any part of either procedure fails, roll everything back?
 
If this is possible, can someone please show me a tiny example of how this would be implemented?
 
EDIT: Procedure "b" fails but procedure "a" still inserts a row into table "a". It's my understanding that if any part of the insert fails that everything (both inserts) is rolled back which is not happening here. The questions is why not?
 
Procedure "a"
 
BEGIN
  DECLARE b INT DEFAULT 0;
  DECLARE EXIT HANDLER FOR SQLWARNING ROLLBACK;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;

  START TRANSACTION;
    INSERT INTO a(a)
    VALUES(iA);

     CALL b(iB,LAST_INSERT_ID(),@b);
     SELECT @b INTO b;

     IF b !=1 THEN
        ROLLBACK;
      ELSE
        COMMIT;
  END IF;
END
 
Procedure "b"
 
BEGIN
  DECLARE b INT DEFAULT 0;
  DECLARE EXIT HANDLER FOR SQLWARNING ROLLBACK;
  DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;

  START TRANSACTION;
    INSERT INTO b VALUES(iB,id);
    SET b=1;
  COMMIT;
END;

原文：https://stackoverflow.com/questions/12827036