DELIMITER $$
CREATE PROCEDURE build_school_list ()
BEGIN
DECLARE v_finished INTEGER DEFAULT 0;
DECLARE v_shcool varchar(100) DEFAULT "";
DECLARE v_shengfen varchar(100) DEFAULT "";
DECLARE v_shi varchar(100) DEFAULT "";
-- declare cursor for employee email
DEClARE school_cursor CURSOR FOR
SELECT 校区,省份,市 FROM school;
-- declare NOT FOUND handler
DECLARE CONTINUE HANDLER
FOR NOT FOUND SET v_finished = 1;
OPEN school_cursor;
get_school: LOOP
FETCH school_cursor INTO v_shcool,v_shengfen,v_shi;
IF v_finished = 1 THEN
LEAVE get_school;
END IF;
update ec_data set 省份 = v_shengfen, 市 = v_shi where 所在校区 = v_shcool;
-- build email list
-- SET email_list = CONCAT(v_email,";",email_list);
END LOOP get_school;
CLOSE school_cursor;
END$$
本文地址:https://blog.csdn.net/yemenlinweihan/article/details/107408477
如对本文有疑问, 点击进行留言回复!!
存在时更新 不存在时新增:merge into using(071问题)
mysql大量的waiting for table level lock怎么办
Leetcode database 刷题 MySQL 简单部分
网友评论