ERROR 1442 (HY000)

How to Resolve ERROR 1362 (HY000): Updating of NEW row is not allowed in after trigger

March 6, 2014December 6, 2022

You might think you can set new values of columns on the new row after inserting in a trigger, but you can't: mysql> delimiter //… Read More »

How to Resolve ERROR 1442 (HY000): Can't update table in stored function/trigger

July 26, 2013December 8, 2022

ERROR 1442 (HY000) The following examples are trying to create triggers to update some data in current table at event AFTER INSERT. Trigger #1: CREATE… Read More »