bitsCN.com
from http://www.devshed.com/c/a/MySQL/Error-Handling-Examples/ Error Handler Examples Here are some examples of handler declarations: If any error condition arises (other than a NOT FOUND ), continue execution after setting l_error=1 : DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET l_error=1; If any error condition arises (other than a NOT FOUND ), exit the current block or stored program after issuing a ROLLBACK statement and issuing an error message: DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; SELECT 'Error occurred