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
Using transactions in MySQL stored procedures