Sometimes we get situations to perform a set of tasks for a result set. There are 2 ways to do it. 1. We can fetch the result set in server side(like php) and loop through the data in server side and execute the stored procedure one by one. 2. We can use cursor to do […]

In my last tip i have explained “How to use a cursor in MYSQL to loop through a result set”.  We use cursor to execute a set of tasks on a result set.   we know that the continue handler updates the ‘done’ variable to 1 when a ‘Not Found’ error occurs.   Imagine a condition where […]