Error handling of a nested stored procedure MYSQL 5.5

I am using MYSQL 5.5 how to do error handling with a nested stored procedure. A practically significant part of the stored procedure, truncates the table, inserts it into select * from and inserts the key into the duplicate update.

If there is any problem with any nested stored procedure, I would like to catch this error or say that the error occurred in this particular stored procedure.

Right now, due to the nested stored procedure, I don't know where the procedure was stored, an exception has occurred.

+3
source share
1 answer

DECLARE ... HANDLER , , ; () , , (), , .

+1

All Articles