CREATE DEFINER=root
@%
PROCEDURE add_order_menu
()
BEGIN
DECLARE flag int default 0;
DECLARE shop_id varchar(500);
DECLARE error varchar(500);
DECLARE s_list cursor for SELECT role_id from sys_role
where type in (0,1) and role_id not in (50,55,57) and real_company_num is not NULL and company_num not in (900000025);
DECLARE continue handler for not found set flag=1;
#异常捕捉防止报错终止服务
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET error =1;
open s_list;
fetch s_list into shop_id;
WHILE flag <> 1 DO
SET @sqlstr = CONCAT(
“insert into sys_role_menu (role_id,menu_id)
select * from(select * from (select “,shop_id,”) a ,(select menu_id from sys_menu
where menu_id in (667,668,669,670,671,672,673,674)
) b) c”
);
prepare stmt from @sqlstr;
execute stmt;
fetch s_list into shop_id;
END WHILE;
close s_list;
END
mysql 存储过程
最新推荐文章于 2023-02-03 13:24:16 发布