MySQL Forums
Forum List  »  Triggers

Re: Triggers can not use reference to tables?
Posted by: Jay Pipes
Date: June 26, 2005 11:28PM

Paul McArdle wrote:
> Currently, triggers have the same limitation as
> stored functions that they may not contain direct
> references to tables by name. This limitation will
> be lifted as soon as possible.


This is not correct. Triggers and functions can now have direct references to tables. I believe it's been this way since 5.0.4 but the manual is lagging a bit behind.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Triggers can not use reference to tables?
2435
June 26, 2005 11:28PM


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.