DROP PROCEDURE IF EXISTS simple.sim_User_list;
CREATE PROCEDURE simple.`sim_User_list`(
)
BEGIN
DECLARE V_name VARCHAR(500) DEFAULT '';
DECLARE tmpname VARCHAR(20) DEFAULT '';
DECLARE v_nametmp VARCHAR(20) DEFAULT '';
DECLARE v_name2 VARCHAR(800) DEFAULT '';
DECLARE isleave BOOLEAN DEFAULT FALSE ;
DECLARE CURS_NO CURSOR
FOR
SELECT
t.Name
FROM
SIMPLE.sim_user t;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET isleave = TRUE;
#DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET tmpname = NULL;
OPEN curs_No;
flagloop:
LOOP
FETCH CURS_NO INTO v_nametmp;
SELECT
v_nametmp;
IF isleave
THEN
LEAVE flagloop;
END IF;
END LOOP;
CLOSE CURS_NO;
/*
OPEN CURS_NO;
FETCH CURS_NO INTO tmpname;
WHILE (tmpname IS NOT NULL)
DO
SET tmpname = CONCAT(tmpname, ',');
SET V_name = CONCAT(V_name, tmpname);
FETCH CURS_NO INTO tmpName;
END WHILE;
SELECT
V_name;
CLOSE CURS_NO;
*/
END;
mySQL游标
最新推荐文章于 2024-08-06 04:32:30 发布