DECLARE no_more_rows BOOLEAN; DECLARE loop_cntr INT DEFAULT 0; DECLARE num_rows INT DEFAULT 0;
DECLARE projects_cur CURSOR FOR SELECT Project_Id FROM Project_Details;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_rows = TRUE;
OPEN projects_cur; select FOUND_ROWS() into num_rows;
the_loop: LOOP
FETCH projects_cur INTO Project_Number_val;
IF no_more_rows THEN CLOSE projects_cur; LEAVE the_loop; END IF;
SET Project_List_val=CONCAT(`Project_Number_val`,'_List') ----> Please check am I doing CONCAT correct here? Insert Into test (Panel_Id) select Panel_Id from Project_List_val where Project_Number_val='9'; --->Is this taking 9_List as table name?
SET loop_cntr = loop_cntr + 1; END LOOP the_loop;
select num_rows, loop_cntr;
END $$# MySQL returned an empty result set (i.e. zero rows).
DELIMITER
Feb 14
Peterson, Timothy R RE: Please check the stored procedure
Feb 14, 2013; 15:49
Peterson, Timothy R
RE: Please check the stored procedure
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!