MySQL Exception - How is Exception Handling handled in MySQL?

How is Exception Handling handled in MySQL?

Exception handling means changing the usual expected flow of the code. This needs to be done to avoid errors. The exceptions in MySql can be handled using the following syntax:
DECLARE handler_type (Continue | Exit) HANDLER FOR condition_value[,...] sp_statement
Here, whenever an error occurs, the handler type value will decide whether to continue or Exit. Continue will execute the next Sql statement while exit will exit the procedure. Condition_value can take number of levels of categories. set condition is used to define code to be performed if the handler is called.
MySQL - What are the Performance and Scalability characteristics of MySQL?
MySQL Performance and Scalability - MySQL has a unique storage engine architecture that makes it adaptable to most servers. MySQL meets the expectations of....
MySQL limitations - What are the limitations of mysql in Comparison of Oracle?
MySQL limitations - Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available....
MySQL Trigger - What is a Trigger in MySQL? Define different types of Trigger?
MySQL Trigger - A trigger is a set of code which is executed in response to some event.....
Post your comment