jTzzePwH

1
2drop procedure IF EXISTS ordoneaza_interese;//
3
4CREATE PROCEDURE ordoneaza_interese(IN comunitate_id INT)
5BEGIN
6
7
8  DECLARE done INT DEFAULT 0;
9  DECLARE rec_cursor VARCHAR(255);
10  DECLARE curs CURSOR FOR select `interese` from users where `comunitate_id`=11;
11  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;  
12
13	DROP TEMPORARY TABLE IF EXISTS test1;
14
15      CREATE TEMPORARY TABLE test1 (      
16				id int(10) unsigned NOT NULL PRIMARY KEY auto_increment,
17        value VARCHAR(255) 
18      ) ENGINE=MEMORY;
19
20  OPEN curs;
21
22  REPEAT
23    FETCH curs INTO rec_cursor;
24    IF NOT done THEN
25       insert into test1 (id, value) VALUES(NULL, rec_cursor); 
26    END IF;
27  UNTIL done END REPEAT;
28
29  CLOSE curs;    
30
31	select * from test1;
32
33END;//
34
35call ordoneaza_interese(11);
36
37#select interese from users where comunitate_id=11