【SQL】SELECTしたデータを１行ずつ読み込む方法について【カーソル】

1DECLARE user_cursor CURSOR FOR
2SELECT
3    user_id,
4    name,
5    age,
6    remarks
7FROM
8    MST_Users;

1DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;

1OPEN user_cursor;
2read_loop: LOOP
3    FETCH user_cursor INTO u_id, u_name, u_age, u_remarks;
4    IF finished = 1 THEN 
5        LEAVE read_loop;
6    END IF;
7    
8    IF u_age >= 18 THEN
9        INSERT INTO adult_Users (user_id, name, age, remarks) VALUES (u_id, u_name, u_age, u_remarks);
10    ELSE
11        INSERT INTO kids_Users (user_id, name, age, remarks) VALUES (u_id, u_name, u_age, u_remarks);
12    END IF;
13END LOOP;
14CLOSE user_cursor;

1DELIMITER $$
2
3CREATE PROCEDURE InsertUsers()
4BEGIN
5  DECLARE finished INTEGER DEFAULT 0;
6  DECLARE u_id INT;
7  DECLARE u_name VARCHAR(100);
8  DECLARE u_age INT;
9  DECLARE u_remarks TEXT;
10  DECLARE user_cursor CURSOR FOR SELECT user_id, name, age, remarks FROM MST_Users;
11  DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished = 1;
12
13  OPEN user_cursor;
14  
15  read_loop: LOOP
16    FETCH user_cursor INTO u_id, u_name, u_age, u_remarks;
17    IF finished = 1 THEN 
18      LEAVE read_loop;
19    END IF;
20    
21    IF u_age >= 18 THEN
22      INSERT INTO adult_Users (user_id, name, age, remarks) VALUES (u_id, u_name, u_age, u_remarks);
23    ELSE
24      INSERT INTO kids_Users (user_id, name, age, remarks) VALUES (u_id, u_name, u_age, u_remarks);
25    END IF;
26  END LOOP;
27  
28  CLOSE user_cursor;
29END$$
30
31DELIMITER ;
32