MySQL Forums
Forum List  »  Triggers

Error creating trigger
Posted by: Gil Katz
Date: August 15, 2006 11:09AM

Hi guy's
Whats wrong with this one?

Create trigger app after update on app_machines
for each row
begin
if NEW.OCCUPIER != NULL Then
insert into history (MACHINE_NAME,USER_NAME,FROM_DATE,TO_DATE)
values (NEW.MACHINE_NAME,NEW.OCCUPIER,NEW.FROM_DATE,NEW.TO_DATE);
End If;
End;
Thanks
Gil

Options: ReplyQuote


Subject
Views
Written By
Posted
Error creating trigger
2336
August 15, 2006 11:09AM
1638
August 15, 2006 01:15PM
1574
August 15, 2006 02:08PM
1580
August 15, 2006 02:21PM
1578
August 16, 2006 09:50AM
1664
August 16, 2006 10:25AM


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.