MySql，存储函数，游标

#存储函数
CREATE FUNCTION fun1(uName VARCHAR(10))
RETURNS INT
BEGIN
	DECLARE num INT;
	SELECT count(1) INTO num FROM u_user t WHERE t.`name`=uName;
	RETURN num;
END;

SELECT fun1('sad'); 

#查询user表数据，并逐行获取进行展示
CREATE PROCEDURE pro_test11()
BEGIN
	DECLARE u_id INT(11);
	DECLARE u_name VARCHAR(10);
	DECLARE u_age INT(11);
	DECLARE u_stats INT(11);
	DECLARE has_data INT DEFAULT 1;
		
	DECLARE user_result CURSOR FOR SELECT * FROM user;
	DECLARE EXIT HANDLER FOR NOT FOUND SET has_data=0;
	
	OPEN user_result;
	REPEAT
		FETCH user_result INTO u_id,u_name,u_age,u_stats;
		SELECT CONCAT("id:",u_id,"namge:",u_name,"age",u_age,"stats:",u_stats);
	UNTIL has_data=0 END REPEAT;

	
	CLOSE user_result;
END;

CALL pro_test11();


DROP PROCEDURE pro_test11;