触发器

--创建触发器

delimiter //
create trigger  触发器名  before(after)  insert(update,delete)  on t1  for each  row
begin
declare a   varchar(20);
declare  b  varchar(20);
set  a=(select name from student);
set  b=(select name  from sanban);
insert into  t(name1,name2)  values(a,b);
end//
delimiter ;