create trigger ins_b_insert before insert on users for each row begin declare stopFlag int; declare dbname varchar(20) default ''; declare stcur cursor for select sitename from test.site; declare continue handler for not found set stopFlag =1; open stcur; repeat fetch stcur into dbname; /*看下面的语句,应该知道意思了吧,DBname就是数据库的名称,这个我不知道证明方到sql中去*/ insert into dbname.users(username,password) select username,password from users where id=new.id; until stopFlag =1 end repeat; close stcur; end;
for each row
begin
declare stopFlag int;
declare dbname varchar(20) default '';
declare stcur cursor for select sitename from test.site;
declare continue handler for not found set stopFlag =1;
open stcur;
repeat
fetch stcur into dbname;
/*看下面的语句,应该知道意思了吧,DBname就是数据库的名称,这个我不知道证明方到sql中去*/
insert into dbname.users(username,password) select username,password from users where id=new.id;
until stopFlag =1
end repeat;
close stcur;
end;