mysql存储过程

BEGIN
	#Routine body goes here...
	DECLARE pic_id int;
	DECLARE homepage_product_id int;
	DECLARE myorder int;
	#遍历数据结束标志
  DECLARE done INT DEFAULT FALSE;
	DECLARE pic_report CURSOR FOR SELECT picId FROM table WHERE typeId = 17;

 #将结束标志绑定到游标
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

	SELECT MAX(orderId)orderId INTO myorder FROM tableWHERE subtypeId = 90;

OPEN pic_report;
-- 开始循环
  read_loop: LOOP
FETCH pic_report INTO pic_id;
IF done THEN
      LEAVE read_loop;
    END IF;
if not EXISTS (select id from table WHERE picId = pic_id AND subtypeId = 90) THEN
	SET myorder = myorder + 1;
	INSERT into table(picId,orderId,typeId,subtypeId) VALUES (pic_id,myorder,98,90);
end if;

END LOOP;
CLOSE pic_report;
	
END