Skip to main content

Mysql Procedure syntax


DROP PROCEDURE `dg`//
CREATE DEFINER=`root`@`localhost` PROCEDURE `dg`(g int(32))
begin
declare p_a int(25);

declare no_more_rows boolean default FALSE;
declare cursor1 cursor for select id from chk;
declare continue handler for not found
set no_more_rows := TRUE;

open cursor1;
Loop1 : loop
fetch cursor1 into p_a;
if no_more_rows then
close cursor1;
leave Loop1;
end if;
select p_a;
end loop Loop1;
end

Comments