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.