Learn SQL Database Programming

Understanding error handling syntax and how to implement error handling

In order to handle errors, you can use special error handling. The syntax for that is as follows:

DECLARE action HANDLER FOR condition statement;

When a condition matches the condition specified in the handler, MySQL will execute the statement specified in the handler and either continue or exit based on the action specified. This statement can be a single statement or multiple statements surrounded by BEGIN and END.

The action specified in the handler can be one of two values:

• Continue: Execution of the code will continue
• Exit: Execution of the code will terminate

The condition specified in the handler can be one of the following:

• A MySQL error code: This will ...