Knowledge Walls
John Peter
Pune, Maharashtra, India
Mysql
Cursor View Trigger Stored Procedure Function
JQuery
HTML-Jquery Program template
JAVA
Main method basic template Class template example
HTML
Table HTML basic template HTML UL Tag Template HTML Form with File Upload Template
Cursor in Mysql of Code Template
7311 Views
Cursor Syntax
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
DECLARE c_rno INT;
DECLARE c_name VARCHAR(100);
 
DECLARE cursor_var CURSOR FOR SELECT rno,name FROM students;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
 
OPEN cursor_var;
 
    cursor_var_loop: LOOP
         FETCH cursor_var INTO c_rno,c_name;
            
         -- cursor loop statements
     
     
         IF done THEN
                LEAVE cursor_var_loop;
         END IF;
    END LOOP;
 
CLOSE cursor_var;
Multiple continue handler template
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
DECLARE c_rno INT;
DECLARE c_name VARCHAR(100);
DECLARE cursor_var CURSOR FOR SELECT rno,name FROM students;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cursor_var;
    cursor_var_loop: LOOP
         FETCH cursor_var INTO c_rno,c_name;
            
 
         -- cursor loop statements
    
         SELECT_BLOCK: BEGIN
             DECLARE CONTINUE HANDLER FOR NOT FOUND
             BEGIN END;
                 
              -- put SELECT statements here if your select statement
              -- has no records then local handler will get fired
             SELECT * FROM table_name WHERE 0;
 
         END SELECT_BLOCK;
 
     
         IF done THEN
                LEAVE cursor_var_loop;
         END IF;
    END LOOP;
CLOSE cursor_var;
Next
Next Topics
Next lessons of current book.
Mysql of Code Template
Mysql of Code Template
Mysql of Code Template
Mysql of Code Template
JQuery of Code Template
Sub Lessons
Nested Cursor
   
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details