MySQL error code
MySQL error 1442
MySQL server error 1442 is ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG, reported with SQLSTATE HY000.
Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
| Error | 1442 |
|---|---|
| Name | ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG |
| SQLSTATE | HY000 |
| Group | Server errors |
Source: MySQL 8.4 Error Reference