Re: Help converting Trigger SQL Server code to MYSQL
Justin
A couple of comments. Firstly you can't currently reference tables in Triggers so inserting deleting and updating inside them is out.
Secondly you have to create a unique trigger for each action, so you can't have a trigger which fires both on an insert or delete.
To answer the actual question, No those virtual tables do not exist, but they would be pointless as we know which we are doing by virtue of the fact they are explicit insert, update, delete triggers.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Subject
Written By
Posted
Re: Help converting Trigger SQL Server code to MYSQL
April 18, 2005 04:17AM
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.