search results

  1. MySQL supports cursors inside ... LOOP is the only construct ... DECLARE CONTINUE HANDLER FOR NOT FOUND SET flag1 = \'END\';-- Open cursor OPEN getDept;-- loop to ...
    dev.mysql.com/doc/refman/5.0/en/​cursors.htm - Cached
  2. Loop inside Loop into Cursor Loop crash: ... (cursor) loop only once and then stop ... END LOOP; END IF; UNTIL done END REPEAT; So the procedure go trough the ...
    bugs.mysql.com/bug.php?id=15579 - Cached
  3. MySQL Working With Cursors ... END; This stored procedure does ... With this functionality in place you can now place any needed processing inside the loop ...
    www.brainbell.com/tutorials/MySQL/​Working_With_Cursors.htm - Cached
  4. See Roland Bouman\'s \"Nesting MySQL Cursor Loops\" article for ... END IF; END block_cursor; END LOOP ... Procedure Within a Cursor Loop, ...
    stackoverflow.com/questions/3224248/​using-cursor-in-a... - Cached
  5. Here’s an example of how to create a MySQL stored procedure that uses a cursor. ... LEAVE the_loop; END IF; ... why did you only explicitly close the cursor when ...
    www.kbedell.com/2009/03/02/a-simple-​example-of-a-mysql... - Cached
  6. If you defined a variable inside block BEGIN/END inside a stored procedure it ... END CASE; Loop in Stored Procedures MySQL ... only for demonstrating how cursors ...
    forums.mysql.com/​read.php?98,358569,358569< /SPAN> - Cached
  7. Handling cursor loops in MySQL ... The only thing that binds the inner BEGIN..END block to ... it\'s own BEGIN..END block: 01 create procedure p_< B>inner_loop
    rpbouman.blogspot.com/2005/10/nesting-​mysql-cursor-loops... - Cached
  8. What\'s more, the procedure does not onl y ... when the cursor is exhausted leave cursor_loop; end ... nesting-mysql-cursor-loops.html http ...
    rpbouman.blogspot.com/2005/09/want-to-​write-cursor-loop... - Cached
  9. In order to create and use cursors in MySQL 5 ... only useful if used in some sort of a loop; ... working with cursors inside a stored procedure and you ...
    www.devshed.com/c/a/MySQL/Delving-​Deeper-into-MySQL-50/2 - Cached
  10. END LOOP ; ... The stored procedure only constructs string with even ... you have learned various MySQL loop statements to execute a block of code ...
    www.mysqltutorial.org/stored-procedures-​loop.aspx - Cached