MySQL Forums
Forum List  »  Triggers

Re: can't update table 'users' in stored function/trigger because
Posted by: irek kordirko
Date: April 18, 2012 03:24PM

Paul Polin Wrote:
-------------------------------------------------------
>
> how can I solve it ?
>

It cannot be solved.

Read FAQ:
http://dev.mysql.com/doc/refman/5.5/en/faqs-triggers.html#qandaitem-B-5-1-9
Quote

B.5.9: Can triggers access tables?

A trigger can access both old and new data in its own table. A trigger can also affect other tables,
but it is not permitted to modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: can't update table 'users' in stored function/trigger because
2426
April 18, 2012 03:24PM


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.