Right-Side Principle for FunctionMarch 5, 2014November 30, 2022Using mixed function arguments should notice the right-side principles, which means you must put the default arguments to the rightmost position in the arguments list… Read More »Right-Side Principle for Function
How to Resolve ERROR 1442 (HY000): Can't update table in stored function/triggerJuly 26, 2013December 8, 2022ERROR 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 »How to Resolve ERROR 1442 (HY000): Can't update table in stored function/trigger