sql/proc_get_act_most_used.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

DELIMITER //
DROP PROCEDURE IF EXISTS get_act_most_used//
CREATE PROCEDURE get_act_most_used()
BEGIN
	DECLARE a CHAR(80);
	DECLARE done INT DEFAULT FALSE;
	DECLARE cur1 CURSOR FOR SELECT name FROM Resources;
	
	OPEN cur1;
	
	read_loop: LOOP
		FETCH cur1 into a;
		IF done THEN
			LEAVE read_loop;
		END IF;
	END LOOP;
END;