Problem implementing creating trigger using MYSQL 5.0
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;
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.