Cursor in Mysql

Tweet

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 ;

Comments (Your Comments)