MySQL Forums
Forum List  »  Triggers

Re: Help for newbie to triggers
Posted by: Greg Johll
Date: September 27, 2005 06:08PM

Thanks for the reply, but now I have doubts that I can even do what I want with this trigger.

From the article:
http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf

"But remember that functions are subject to severe limitations: you cannot access tables from within a function. So these statements are illegal inside a function:

ALTER 'CACHE INDEX' CALL COMMIT CREATE DELETE DROP 'FLUSH PRIVILEGES' GRANT INSERT KILL LOCK OPTIMIZE REPAIR REPLACE REVOKE ROLLBACK SAVEPOINT 'SELECT FROM table' 'SET system variable' 'SET TRANSACTION' SHOW 'START TRANSACTION' TRUNCATE UPDATE

Precisely the same limitation applies for triggers."

So my attempt to DELETE from another table is not possible from a trigger. Correct?

Thanks,
Greg

Options: ReplyQuote


Subject
Views
Written By
Posted
2922
September 26, 2005 08:44PM
2023
September 26, 2005 08:49PM
Re: Help for newbie to triggers
2122
September 27, 2005 06:08PM
1694
September 27, 2005 06:33PM
2019
September 27, 2005 07:55PM


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.