Skip to main content

Error Handling in Procedures

Learn Error Handling in Procedures (Stored Procedures, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Errors are handled with handlers : DECLARE CONTINUE|EXIT HANDLER FOR condition statement . A condition can be an SQLSTATE, a MySQL error number, SQLEXCEPTION , SQLWARNING or NOT FOUND . SIGNAL raises your own error and RESIGNAL rethrows.

More lessons in Stored Procedures