解决方案:
从A表取一个字段的值和从B表取一个字段的值一一组合作为插入数据源。
drop procedure if exists test_team_user;
create PROCEDURE test_team_user()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE userid VARCHAR(32);
DECLARE teamid VARCHAR(32);
DECLARE id int DEFAULT 100;
/*声明一个游标*/
DECLARE c_userid cursor for select user_id from sys_user where account like 'dor%'or account like 'nur%';
/* 异常处理 */
declare CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1;
/*打开游标*/