mysql - 同一个表上的 Insert 触发器中的更新语句

Question

我想编写一个触发器，其中包含同一个表上的 UPDATE 语句，如下所示:

create trigger AFTER INSERT ON myTable
   FOR EACH ROW BEGIN
    update myTable set ... where ...
   end

我该怎么做？

Answer 1

Quoting MySQL docs :

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.