Mysql存储过程中的事务回滚

create procedure test(in a int)BEGINDECLARE t_error INTEGER DEFAULT 0;DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;-- 异常时设置为1START TRANSACTION;INSERT into aaaa VALUES(2,3);INSERT into aaaaa VALUES(2,3);IF t_error = 1 THENROLLBACK;ELSECOMMIT;END IF;END