You're missing
BEGIN keyword after the
FOR EACH ROW clause.
The entire syntax diagram for the
CREATE TRIGGER statement is
here (true, quite overwhelming, but sometimes indispensable). A guide on triggers (containing some examples) can be found
here.
However, your
insert syntax is also wrong. Generally, syntax statements look like
The values can be literals, variables or expressions in general.
And lastly, it is not entirely clear what
NUM1 and
NUM2 are. If they are columns in the
TESTING table, you need to access them using the
:new variable, eg.
:new.num1.