DROP PROCEDURE IF EXISTS build_Code;
delimiter $$
CREATE PROCEDURE build_Code
()
BEGIN
DECLARE finished INTEGER DEFAULT 0;
DECLARE TBLCOD1 varchar(100) ;
DECLARE DMGRP1 varchar(100) ;
DECLARE FLDCOD1 varchar(100) ;
DECLARE cursor_name CURSOR FOR
SELECT TBLCOD,DMGRP,FLDCOD FROM s_information;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;
OPEN cursor_name;
get_CUR:LOOP
FETCH cursor_name INTO TBLCOD1,DMGRP1,FLDCOD1;
IF finished =1 THEN
LEAVE get_CUR;
END IF;
PREPARE pr1 FROM 'update s_fieldsdefine_copy set DMGRP= ? where TBLCOD = ? and FLDCOD = ?';
SET @a=DMGRP1,@b=TBLCOD1,@c=FLDCOD1;
EXECUTE pr1 USING @a, @b, @c;
END LOOP get_CUR;
CLOSE cursor_name;
END$$
delimiter ;
