MySQL Simple cursor

Example of <=====================mysql Tour signs =====================>

CREATE PROCEDURE ' test '. ' New_procedure ' ()
BEGIN
--need to define variables that receive cursor data
DECLARE a CHAR (16);
--Traversal data End flag
DECLARE done INT DEFAULT FALSE;
--Cursors
DECLARE cur CURSOR for SELECT c_username from T_userinfo;

--Bind the end flag to the cursor
DECLARE CONTINUE HANDLER for don't FOUND SET done = TRUE;
--Open cursor
OPEN cur;

--Start cycle
Read_loop:loop
--Extract the data in the cursor, there is only one, and many words are the same;
FETCH cur into A;
-At the end of the declaration
IF do Then
LEAVE Read_loop;
END IF;
--Here's what you want to do with the loop of events

INSERT into T_test VALUES (a);

END LOOP;
--Close cursor
CLOSE cur;
END

MySQL Simple cursor