Sql存储过程基础

BEGIN
DECLARE _zhiGongID VARCHAR(25);
DECLARE _zhiGongGH VARCHAR(25);
DECLARE _zhiGongXM VARCHAR(25);
#定义游标，并将sql结果集赋值到游标中
DECLARE num INT DEFAULT 0;
#定义游标，并将sql结果集赋值到游标中
DECLARE jsyh_list CURSOR FOR SELECT ZhiGongID,ZhiGongGH,ZhiGongXM FROM cmp_sys.rms_jueseyh where ID < 10;
#当游标遍历完成后，该改变游标标志值
DECLARE CONTINUE HANDLER FOR NOT FOUND SET num = 1;
OPEN jsyh_list;
#按结果集顺序赋值变量
FETCH jsyh_list INTO _zhiGongID,_zhiGongGH,_zhiGongXM;

WHILE num <> 1 DO
INSERT INTO cmp_sys.rms_khjlambxx(ZhiGongID,ZhiGongGH,ZhiGongXM) VALUES(_zhiGongID,_zhiGongGH,_zhiGongXM);
FETCH jsyh_list INTO _zhiGongID,_zhiGongGH,_zhiGongXM;
END WHILE;
CLOSE jsyh_list;
END

Sql存储过程基础

原文：https://www.cnblogs.com/pingfandeyisheng/p/11156958.html