MySQL stored procedures (cursors)

BEGIN
DECLARE userid varchar (64); --ID
--Traversal data End flag
DECLARE done INT DEFAULT FALSE;
--Cursors
DECLARE cur_account CURSOR for select id from S_user where 1=1;
--Bind the end flag to the cursor
DECLARE CONTINUE HANDLER for don't FOUND SET done = TRUE;
--Open cursor
OPEN Cur_account;
--Traversal
Read_loop:loop
--Take a value to take multiple fields
FETCH NEXT from Cur_account to UserID;
IF do Then
LEAVE Read_loop;
END IF;

--The operation you want to do
Insert into S_user_role (Uid,rid) value (userid,7);
Insert into S_user_role (Uid,rid) value (userid,19);
END LOOP;
CLOSE Cur_account;
END

MySQL stored procedures (cursors)