MySQL Forums
Forum List  »  Microsoft SQL Server

Problem implementing creating trigger using MYSQL 5.0
Posted by: suchi madala
Date: October 30, 2005 06:48PM

Can anyone help with this. I am struggling to know wants wrong with it. I think i might made a mistake since i dunno the way to use the delimiters.
Here I want to set the date each time insert is performed on my orders table using the following triggers using MYSQL 5.0. Please help me to solve this

CREATE TRIGGER orders_update ON Orders
FOR INSERT AS
BEGIN
UPDATE Orders SET order_date = GetDate() WHERE ordernum = (SELECT ordernum FROM inserted);
END;

Options: ReplyQuote


Subject
Written By
Posted
Problem implementing creating trigger using MYSQL 5.0
October 30, 2005 06:48PM


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.