MySQL stored procedure-cursor usage fetch each row of records (multiple fields)

Delimiter $create PROCEDURE phonedeal () BEGIN    DECLARE  ID varchar (+);   --ID    DECLARE  phone1  varchar (+);--Phone    DECLARE  password1  varchar (32);--Password    DECLARE  name1 varchar (+);   --ID    --traverse end of data flag    DECLARE done INT DEFAULT FALSE;    --Cursor    DECLARE cur_account cursor for select phone,password,name from Account_temp;    --binds the end flag to the cursor    DECLARE CONTINUE HANDLER for not FOUND SET do = TRUE;       --Opening the cursor open  cur_account;          --Traverse    read_loop:loop            --Fetch multiple fields            fetch NEXT from Cur_account to  phone1,password1,name1;             IF do then                LEAVE read_loop;             END IF;        --The action you want to do insert into account        (id,phone,password,name) value (UUID (), Phone1,password1,concat (name1, ' parent '));    END LOOP;    CLOSE Cur_account; END $

　　

MySQL stored procedure-cursor usage fetch each row of records (multiple fields)