Skip navigation links

MySQL Forums :: Triggers :: can't update table 'users' in stored function/trigger because


Advanced Search

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
can't update table 'users' in stored function/trigger because 2149 Paul Polin 04/18/2012 12:54AM
Re: can't update table 'users' in stored function/trigger because 1390 irek kordirko 04/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.