create trigger tri_test1 after insert on A for each row begin insert into B(name,age) values(new.name,new.age); end
create trigger tri_test2 after update on A for each row begin delete B where id=delete.id; insert into B(id,name,age) values(new.id,new.name,new.age); end
after insert
on A for each row
begin
insert into B(name,age) values(new.name,new.age);
end
after update
on A for each row
begin
delete B where id=delete.id;
insert into B(id,name,age) values(new.id,new.name,new.age);
end