DELIMITER $$
DROP PROCEDURE IF EXISTS `procedure_course`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `topsale`.`procedure_course`()
BEGIN
DECLARE c_user_login_id VARCHAR(100);
DECLARE done INT DEFAULT 0;
##1.定义游标stock_cursor 根据指定用户id
DECLARE stock_cursor CURSOR FOR SELECT ul.USER_LOGIN_ID FROM user_login ul WHERE ul.party_id='999' AND user_login_id='eric.zhang';##获取本部所有用户id
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
OPEN stock_cursor;##2.打开游标
cursor_loop: LOOP
FETCH stock_cursor INTO c_user_login_id; ##3.提取游标
IF done=1 THEN
LEAVE cursor_loop;
END IF;
CALL procedure_course_mapping(c_user_login_id);
END LOOP cursor_loop;
CLOSE stock_cursor; ##关闭游标
END$$
DELIMITER ;
DELIMITER $$