1 of 1

Error 1442: Can't update table in stored function/trigger because it is already used by statement wh

Error Code

SQLSTATE

Error

Description

1442

HY000

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.

Possible Causes and Solutions