MySQL exception handling

CREATE definer= ' root ' @ ' localhost ' PROCEDURE ' pr_exception ' (i_date varchar), out o_error_code  varchar ($), out o_error_msg  varchar (begin--) Custom exception declare my_error CONDITION for SQLSTATE ' 45000 '; DECLARE EXIT HANDLER for My_error begin  Set o_error_code:=-100,o_error_msg:= ' custom error message '; ROLLBACK; End --Define exception DECLARE EXIT HANDLER for SQLEXCEPTION  BEGIN      GET Diagnostics CONDITION 1        o_error_code = Returned_sqlst ATE, o_error_msg = Message_text;        Rollback --rollback    END;     START TRANSACTION; --Open transaction if i_date = ' 0 ' thensignal my_error; --Trigger custom exception end If;insert into ACC_CELLSTK (fundid_) values (1);  --Correct Sqlinsert into ACC_CELLSTK (fundid_) VALUES (' s ');  --Error SQL throws exception commit; END

　　

MySQL exception handling