does mysql's innodb engine supports trigger

[mukeshrasm]

Hi

I am not able to execute a trigger it is giving error at line 4 and the syntex for the trigger is here

create trigger abc before insert on triggertest
for each row begin
insert into triggerinsert (beforeinsert)( select count(*) from triggertest);

end;

I tried to execute this but giving error then i tried to execute this

create trigger abc before insert on triggertest
for each row begin
insert into triggerinsert (beforeinsert)( select count(*) from triggertest)

end;

and at last i tried to execute this but same result

create trigger abc before insert on triggertest
for each row begin
insert into triggerinsert (beforeinsert)( select count(*) from triggertest)

So if any one please let me know where is the problem

[ronverdonk]

As far as I can see all 3 pieces of code shown are identical. Please show the correct ones.

Ronald