MySQL Forums
Forum List  »  Triggers

Re: begin .. for each row in other table{ } ... end
Posted by: davy timmermans
Date: April 01, 2006 11:52AM

something like
create trigger tester
after insert on client
for each row
BEGIN
@id= select s.sid from salesman s;
INSERT
INTO clientUsers
values(@id,new.cid,'I');
END


this doesn't work->error



Edited 1 time(s). Last edit at 04/01/2006 12:09PM by davy timmermans.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: begin .. for each row in other table{ } ... end
2396
April 01, 2006 11:52AM


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.