MySQL Forums
Forum List  »  Triggers

why the trigger is not working while refering other tables?
Posted by: junjie_1982
Date: June 28, 2005 09:16AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
why the trigger is not working while refering other tables?
7083
June 28, 2005 09:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.