YWExcJpu

1
2
3delimiter $$
4create procedure pp1()
5begin
6
7declare id int default 0;
8declare count int default 0;
9declare co varchar(100);
10declare  value int;
11declare var varchar(100);
12DECLARE c1 CURSOR FOR SELECT country FROM countries;
13
14DECLARE CONTINUE HANDLER FOR NOT FOUND SET id = 1;
15open c1;
16mainLoop:loop
17fetch c1 into co;
18
19if id=1 then
20leave mainLoop;
21end if;
22SET count=count+1;
23SELECT co;
24select count;
25create table if not exists co (id int NOT NULL PRIMARY KEY AUTO_INCREMENT,country varchar(20));
26
27
28
29
30
31end loop mainLoop;
32
33end $$
34delimiter ;