Revision: 50396
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at August 19, 2011 16:00 by georgemathewkunnathoor
Initial Code
drop procedure if exists cur_movie;
delimiter //
create procedure cur_movie()
begin
declare mname varchar(100);
declare yr int;
declare flag int default 0;
declare c cursor for select movie_name,release_year from movie;
declare exit handler for not found set flag=1;
open c;
fetch c into mname, yr;
loop
select mname as MovieName ,yr as ReleaseYear;
fetch c into mname,yr;
end loop;
close c;
end //
delimiter ;
Initial URL
http://www.gladsys.in/blog/stored-procedures-in-mysql/
Initial Description
Initial Title
Cursor in Mysql
Initial Tags
mysql
Initial Language
SQL