mysql存储过程

mysql存储mysql存储过程

DROP PROCEDURE IF EXISTS create_notification;
create procedure create_notification()
begin
 DECLARE i INT DEFAULT 0;
 DECLARE done INT DEFAULT 0;
 DECLARE custidval varchar(12);
 # 定义游标
 DECLARE cur CURSOR FOR select DISTINCT(CUSTID) as custidval FROM saleorderdb.cust_custinfo where custid is not NULL;
 # 定义结束
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 # 打开游标
 open cur;
 # 循环游标的值
 FETCH NEXT FROM cur INTO custidval;
 REPEAT
	IF NOT done THEN 
			select i;
			set i=i+1;
	    INSERT INTO saleorderdb.ucs_notification (ID, custid, templateid, status, type, title, content, create_time, modify_time, plan_send_time, APPSHEETSERIALNO) VALUES 
	    (i,custidval,NULL, '0', '01', '标题', '存入数据', 
	    	'20210622000000', NULL, '20210622000000', NULL);
	END IF ;
	FETCH NEXT FROM cur INTO custidval;
	# 判断是否结束
	UNTIL done END REPEAT ;
 CLOSE cur;
end