mysql 存储过程记录

CREATE PROCEDURE `procedure_name` ()
BEGIN
DECLARE a int;
    DECLARE done INT DEFAULT FALSE;
    declare _cur CURSOR for  (select ID from common.sys_column where table_name in ('ORDERFIX_PUR_PACK'));
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    open _cur;
    loop_label:loop
        FETCH _CUR into a;
        IF done THEN
            LEAVE loop_label;
        END IF;    
        insert common.app_sys_column values ('fa5ceca63b9f4a1fae2cd3761462f5f0',a);
    end loop;
    close _cur;
END