本文共 2133 字,大约阅读时间需要 7 分钟。
drop procedure if exists insert_cluster_commongroup;delimiter $create PROCEDURE insert_cluster_commongroup()BEGIN DECLARE clusterId_new varchar(16); -- phone -- 遍历数据结束标志 DECLARE done INT DEFAULT FALSE; -- 游标 DECLARE cur_account CURSOR FOR select clusterId from dapmanager_cluster where clustername not in ('defaultCluster','managerService'); -- 将结束标志绑定到游标 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; -- 打开游标 OPEN cur_account; -- 遍历 read_loop: LOOP -- 取值 取多个字段 FETCH NEXT from cur_account INTO clusterId_new; IF done THEN LEAVE read_loop; END IF; if not exists (select group_id from dapmanager_usergroup where cluster_id = clusterId_new and group_name = 'commongroup') then -- 你自己想做的操作 INSERT INTO `dapmanager_usergroup` (cluster_id, group_name,note,visible_status,create_time,latest_update_time,added_by_id,upd_by_id,group_type,cred_store_id,group_src,status,delmark) VALUES (clusterId_new, 'commongroup', '', '1', '2019-07-08 16:36:51.076', '2019-07-08 16:36:51.076', '0', '0', '1', '0', '0', '0', '0'); end if; END LOOP; CLOSE cur_account;END $delimiter ;call insert_cluster_commongroup();drop procedure if exists insert_cluster_commongroup;
delimiter $create PROCEDURE phoneDeal()BEGIN DECLARE id varchar(64); -- id DECLARE phone1 varchar(16); -- phone DECLARE password1 varchar(32); -- 密码 DECLARE name1 varchar(64); -- id -- 遍历数据结束标志 DECLARE done INT DEFAULT FALSE; -- 游标 DECLARE cur_account CURSOR FOR select phone,password,name from account_temp; -- 将结束标志绑定到游标 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE; -- 打开游标 OPEN cur_account; -- 遍历 read_loop: LOOP -- 取值 取多个字段 FETCH NEXT from cur_account INTO phone1,password1,name1; IF done THEN LEAVE read_loop; END IF; -- 你自己想做的操作 insert into account(id,phone,password,name) value(UUID(),phone1,password1,CONCAT(name1,'的家长')); END LOOP; CLOSE cur_account;END $
转载地址:http://jhwci.baihongyu.com/