why the trigger is not working while refering other tables?

[junjie_1982]

i tried to use mysql trigger but it seems like it's not worked while using query which refering other tables......

create trigger R2BS
after update on registeredUser
for each row
begin

If new.activation <> 0 then

Insert into Seller values(new.UserID,default,default,default);
Insert into Bidder values(new.UserID,default,default,default);

end if;

end //

it's not working as well even if using insert into <database>.<table> values

however it's fired when i changed to use select current_date for testing purpose...

create trigger R2BS
after update on registeredUser
for each row
begin

If new.activation <> 0 then

select current_date；

end if;


is it one of the limitations? if so, that is really a pity.