ERROR 1093 (HY000): You can't specify target table ' ' for update in FROM clause

ERROR 1093 (HY000): You can't specify target table ' ' for update in FROM clause

This error is generated due to wrong logic used in trigger,
that we can not use the same table in trigger, which is being used in external insert / update query.

To overcome, this error, use any external function or in-built function to set the value to filed in trigger.

similar post : -

ERROR 1442 (HY000): Can't update table ' ' in stored function/trigger because it is