INSERT and DELETE on trigger

[André Carvalho]

Hello all,

I have downloaded the 5.03 version and I'm having a hard time on this. I have 2 tables(alpha , beta) I want a trigger on alpha that verify a varchar field if it is = "BETA" then it should be insert to database BETA. Is it possible using trigger???

This is what I thought about, but it isnt working:

create trigger tr_alarme BEFORE INSERT on ALPHA
FOR EACH ROW
BEGIN
IF NEW.name = "ALARM" THEN
insert into beta (name) values (new.name);
END IF;
END//

Thanks for your help.