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

This page is licensed: CC BY-SA / Gnu FDL

Last updated

Was this helpful?