mysql存储过程

DELIMITER $$

DROP PROCEDURE IF EXISTS `xh_cloud_desk_dev`.`insert1`$$

CREATE DEFINER=`root`@`%` PROCEDURE `insert1`()
BEGIN
	DECLARE v int;
	SET v = 0;
	LOOP_LABLE:loop
		set v=v+1;   
		if v >=100 then  
			leave LOOP_LABLE;
		end if;  
	END loop;
    END$$

DELIMITER ;

DELIMITER $$

DROP PROCEDURE IF EXISTS `xh_cloud_desk_dev`.`insert3`$$

CREATE DEFINER=`root`@`%` PROCEDURE `insert3`()
BEGIN
	DECLARE id int;
	DECLARE userid int;
	DECLARE depcode int;
	DECLARE temp_du_id int;
	SET id = 0;
	SET userid = 0;
	SET depcode = '0000';
	SET temp_du_id = 1;
	LOOP_LABLE:loop
		if temp_du_id > 13756 then 
			leave LOOP_LABLE;
		end if;

		select pcm.uid into userid from temp_du td inner join pre_common_member pcm on td.username = pcm.username where td.id = temp_du_id;
		select pd.depcode into depcode from temp_du td inner join pre_departments pd on td.deptname = pd.depname where td.id = temp_du_id;

		insert into pre_user_department_relative values(id, userid, depcode);

		SET temp_du_id=temp_du_id + 1;
	end loop;
    END$$

DELIMITER ;