1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
CREATE PROCEDURE list_projects (IN a_id INT, OUT list VARCHAR(255))
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE c1 CURSOR FOR SELECT project_id FROM mantis_project_action_association_table WHERE action_id = id;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
DECLARE i INT(10);
DECLARE project INT(10);
DECLARE project_count INT(10);
DECLARE project_name VARCHAR(80);
OPEN c1;
REPEAT
FETCH c1 INTO project;
project_name = SELECT name FROM mantis_project_table WHERE id = project;
list := project_name || " ";
UNTIL done END REPEAT;
CLOSE c1;
END
/ |
Partager