MySQL Forums
Forum List  »  Triggers

Re: new to triggers, need some hint
Posted by: joewaster
Date: August 17, 2006 04:18PM

CREATE TRIGGER orders_logging
AFTER INSERT ON orders
FOR EACH ROW
BEGIN
INSERT INTO orders_log (`SourceID`)
VALUES (NEW.id);
END;


this for some reason gives a syntax error...

am i missing something?

Options: ReplyQuote


Subject
Views
Written By
Posted
2441
August 17, 2006 03:04PM
1554
August 17, 2006 03:29PM
Re: new to triggers, need some hint
1619
August 17, 2006 04:18PM
1685
August 17, 2006 04:29PM
1708
August 18, 2006 11:51AM


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.