In this post, you’ll learn more about the MariaDB Error 1442 ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1442 – ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG with the sqlState HY000
Error Description for the MariaDB Error ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG
Can’t update table ‘%s’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger.