MySQL Forums
Forum List  »  Triggers

Re: CALL In Trigger
Posted by: Dmitri Lenev
Date: May 25, 2005 11:54AM

Hi, Tim!

Tim Shor wrote:
> Will the regular sql statements (SELECT ... FROM ... WHERE ...)
> be supproted in the triggers as well?

Yes they will. Of course you won't be able to use in trigger statement
which directly returns result to the client (like simple SELECT), but it
will be perfectly OK to work with SELECT via cursor or use SELECTs
which store their result in variables.

And as I've already said in another thread on this forum we plan to allow
access to other tables from triggers in 5.0 branch. So probably you will be
able test this feature in nearest couple of months.

Hope this helps!

Dmitri Lenev, Software Developer
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
5053
March 10, 2005 02:22PM
2650
March 11, 2005 02:29AM
2327
March 11, 2005 03:50PM
2455
May 06, 2005 03:38AM
2465
May 24, 2005 10:35AM
Re: CALL In Trigger
2521
May 25, 2005 11:54AM


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.