1、函数-新建-过程,比如多个查询,1个变量入参:
BEGIN
-- 查询1 CALL executeMultipleQueries(472963889684549); -- 替换()为你的参数值 472963889684549
SELECT * FROM `ecs-signuser-sit`.rn_seal WHERE realNameId = myVariable;
-- 查询2
SELECT * FROM `ecs-esign-sit`.ecs_esign_seal WHERE sealId IN(SELECT sealId FROM `ecs-signuser-sit`.rn_seal WHERE realNameId = myVariable);
-- 查询3 机构更名 重新开户:raAccountId更新
SELECT t.*, s.raAccountId FROM `ecs-esign-sit`.ecs_esign_account t, `ecs-esign-sit`.ecs_esign_account_status s
WHERE t.accountCode = s.accountCode
AND t.accountCode IN (SELECT accountCode FROM `ecs-esign-sit`.ecs_esign_account WHERE bUserId = myVariable);
-- 查询4 产品更名 bUserName字段更新
SELECT * FROM `ecs-esign-sit`.ecs_esign_account_proxy WHERE bUserId =myVariable;
-- 查询5 机构账号ID
select * from `ecs-esign-sit`.ecs_esign_seal where accountCode in
(SELECT accountCode FROM `ecs-esign-sit`.ecs_esign_account WHERE bUserId=myVariable);
-- 电子证书印章表 ecs_esign_seal.accountCode=账号ID
-- 电子证书开户要素表 ecs_esign_account.accountCode=账号ID 自然人、机构
END
2、函数-新建-函数