Using transactions in MySQL stored procedures

1  DROP PROCEDURE IF EXISTSTEST_SP12  CREATE PROCEDURETest_sp1 ()3     BEGIN  4     DECLARET_errorINTEGER DEFAULT 0; 5     DECLARE CONTINUEHANDLER forSQLEXCEPTIONSETT_error=1; 6   7STARTTRANSACTION; 8             INSERT  intoTestVALUES(NULL,'Test SQL 001'); 9             INSERT  intoTestVALUES('1','Test SQL 002'); Ten    One         IFT_error= 1  Then   A             ROLLBACK;  -         ELSE   -             COMMIT;  the         END IF;  -    -  END

Returns the execution state, which is either committed or rolled back:

1 DROP PROCEDURE IF EXISTSTEST_SP12 CREATE PROCEDURETest_sp1 ()3     BEGIN  4     DECLARET_errorINTEGER DEFAULT 0; 5     DECLARE CONTINUEHANDLER forSQLEXCEPTIONSETT_error=1; 6   7STARTTRANSACTION; 8             INSERT  intoTestVALUES(NULL,'Test SQL 001'); 9             INSERT  intoTestVALUES('1','Test SQL 002'); Ten    One         IFT_error= 1  Then   A             ROLLBACK;  -         ELSE   -             COMMIT;  the         END IF;  -     Select  t_error; Returns the result set of the identity bit;   - END