create database trigger_tester;
use trigger_tester;
create table test1(id int not null AUTO_INCREMENT, name varchar(20), primary key(id));
create table test2(id int not null, name varchar(20), primary key(id));
create trigger after_insert after insert on test1 for each row insert into test2 (id, name) values(NEW.id, concat(NEW.name,' trigger'));
create trigger after_delete after delete on test1 for each row delete from test2 where id = OLD.id;
create trigger after_update after update on test1 for each row update test2 set name = CONCAT(old.name, ' updated') where id = OLD.id;
insert into test1 (name) values('new test');
insert into test1 (name) values('new test2');
insert into test1 (name) values('new test3');
select * from test1;
select * from test2;
delete from test1 where id =2;
select * from test1;
select * from test2;
update test1 set name="new test2" where id =3;
select * from test1;
select * from test2;