Error Handler Examples for all 3 Error Type Options

DECLARE CONTINUE HANDLER FOR 1329

SET row_not_found = TRUE

The easiest and least precise Option: An Example using a built in Handler

DECLARE CONTINUE HANDLER FOR NOT FOUND

SET row_not_found = TRUE

DECLARE CONTINUE HANDLER FOR SQLSTATE '02000'

SET row_not_found = TRUE

The generic moderately precise Option: An Example using a SQL State Code

The most precise Option: An Example using a MySQL Error Code

The Differences are here