Re: Update with join

[Devart Team]

Check the triggers. You have created triggers ON acl_table, and then you are trying to modify this table, it is not possible.
From the reference - Within a stored function or trigger, 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.

Also, you have two 'AFTER UPDATE ON gatekeeper.acl_table' triggers, MySQL does not allow this.
From the reference - There cannot be two triggers for a given table that have the same trigger action time and event. For example, you cannot have two BEFORE UPDATE triggers for a table. But you can have a BEFORE UPDATE and a BEFORE INSERT trigger, or a BEFORE UPDATE and an AFTER UPDATE trigger.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/