| SQL / MySQL » Procedure Function » Condition HANDLER |
| 1. | Declaring a Condition and Handler | ||
| 2. | Declaring a Condition and Handler in action | ||
| 3. | DECLARE CONTINUE HANDLER FOR NOT FOUND SET | ||
| 4. | Checking flag | ||
| 5. | Using while to check the condition | ||
| 6. | DECLARE EXIT HANDLER FOR | ||
| 7. | Checking Exit flag | ||
| 8. | Using the IF statement to verify 'CONTINUE HANDLER' | ||
| 9. | The example associates a handler with SQLSTATE 23000, which occurs for a duplicate-key error | ||
| 10. | To ignore a condition |