mySQL游标

最新推荐文章于 2025-04-16 05:35:32 发布

原创最新推荐文章于 2025-04-16 05:35:32 发布 · 679 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #user #null #list

ORACLE 专栏收录该内容

24 篇文章

订阅专栏

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;