Facebook
From mati, 4 Years ago, written in SQL.
This paste is a reply to Untitled from mati - go back
Embed
Viewing differences between Untitled and Re: Untitled
CREATE DEFINER=`jkt44`@`localhost` PROCEDURE `dupa`()
BEGIN
        

                                        DECLARE cur INT(11);
                    DECLARE id_zawodu INT;
                    DECLARE finished INTEGER DEFAULT 0;
                    DECLARE salaryOverflow INTEGER DEFAULT 0;
               
                    DECLARE curID
                        CURSOR FOR
                            SELECT id FROM osoba;
                           
                    DECLARE CONTINUE HANDLER
                        FOR NOT FOUND SET finished = 1;
                 
                    OPEN curID;
                                main_loop: LOOP
                                        IF finished THEN
                                        LEAVE main_loop;
                                        END IF;
                       
                        FETCH curID INTO cur;
                       
                        SELECT cur;
                    END LOOP;
                    CLOSE curID;


END

Replies to Re: Untitled rss

Title Name Language When
Re: Re: Untitled mati sql 4 Years ago.