
游标
复制DECLARE at_end INT DEFAULT 0; DECLARE PIID INTEGER DEFAULT 0 ; DECLARE PINT INTEGER DEFAULT 0 ; DECLARE not_found CONDITION FOR SQLSTATE 02000; --DECLARE PCOUNT INTEGER; DECLARE c1 CURSOR FOR SELECT IID FROM YH; DECLARE CONTINUE HANDLER FOR not_found SET at_end = 1; OPEN c1; SET PCOUNT=0; ins_loop: LOOP FETCH c1 INTO PIID; IF at_end <>0THEN LEAVE ins_loop; END IF; SET PCOUNTPCOUNT=PCOUNT+1; SELECT IID INTO PINT FROM YH WHERE 0=1; END LOOP; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.
(责任编辑:系统运维)