Why is it necessary to declare NOT FOUND handler while using MySQL cursor?

We must have to declare NOT FOUND handler while working with MySQL cursor because it handles the situation when cursor could not find any row. It also handles the situation when the cursor reaches the end of the row because every time we call FETCH statement the cursor finds to attempt the next row in the result set. Following is the syntax to declare NOT FOUND handler −

DECLARE CONTINUE HANDLER FOR NOT FOUND SET var_name = value;

Here var_name is the name of any variable and value would be the value of that variable. For example, we can declare it as follows −

DECLARE CONTINUE HANDLER FOR NOT FOUND SET err = 1;

Varun

Published on 21-Feb-2018 11:19:11

• Related Questions & Answers
• In MySQL, how can we declare a handler while handling errors?
• Is it necessary to add DEFAULT NULL in MySQL?
• What is mundan ceremony or mundan sanskar and why is it necessary?
• Why is it necessary to have a girl or boyfriend in life?
• Why is pre-marital counselling necessary?
• Why is it bad to watch TV while eating?
• Why Aural rendering of documents is necessary
• Why is feedback necessary for good business?
• Is it necessary to have a responsive website?
• Why there is not do...while loop in Python?
• What is MySQL NOT NULL constraint and how can we declare a field NOT NULL while creating a table?
• Why a mentor is necessary in life to achieve success?
• What is Ashwagnadha and where is it largely found?
• Why is social reputation necessary for the scientific community people?
• Why is it not good practice to use date values with two-digits years in MySQL?