Help me in creating a Trigger for Insert and Update Options

[Ravi Kiran Va]

Hi

Please help me in creating a Trigger .

My requirement is that after insert or update on a Table , i want to fire an event .

I have started this way ,but doesn't know how to fully implement this .

say i have a dept table

CREATE TRIGGER DepartmentTrigger
AFTER INSERT ON Dept
BEGIN
INSERT INTO mytable VALUES("123","Kiran");
END DepartmentTrigger;

Please tell me how can i put the Update option also .

Thanks in advance .

[Jeanne Boyarsky]

You add it to the "after" clause on the trigger. See the full syntax for triggers.