MySQL Forums
Forum List  »  Triggers

Re: Triggers can not use reference to tables?
Posted by: Chagh
Date: June 28, 2005 12:37AM

Thank you alot Jay
so what should i do with this trigger of SQLServer? how can i translate it to MySQL?

CREATE TRIGGER DeleteDocument ON [dbo].[_Documents] 
FOR DELETE 
AS
          DELETE
          FROM    _RelatedDocs
          WHERE RelatedDocCode IN ( SELECT  DocCode
                                                  FROM     DELETED )

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Triggers can not use reference to tables?
2370
June 28, 2005 12:37AM


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.