MySQL Forums
Forum List  »  Triggers

Re: pass table name from trigger to procedure?
Posted by: Bob Field
Date: May 19, 2006 03:29PM

Since the trigger is specific to a table, pass the name of the table as a constant string. In the sproc, used a prepared statement to execute the deletion.

http://dev.mysql.com/doc/refman/5.0/en/sqlps.html

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: pass table name from trigger to procedure?
3305
May 19, 2006 03:29PM


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.