sql - mysql trigger stored trigger is already used by statement which invoked stored trigger -
I want to set a trigger so that in the forecast forecast area = 3, the trigger value changes 4 and the database In it saves it. The trigger is below
For some reason I'm getting an error saying:
# 1442 - The table in the stored function / trigger 'tzanalytic \ _forecast \ _cached' update Can not be done because it is already used by the statement which implements this stored function / trigger.
Is this installed correctly?
Delimiter $$ before creating an order for Trader no. Forecast; Update T Set T. Amendment = (if selected (@ prediction = '3', '4', @ estimate)) where t. Event_id = new.event_id and t.price_tier = new.price_tier; End; $$ delimiter;
MySQL can not manipulate the tables assigned to them to trigger all others Major DBMS supports this feature, so it is expected that MySQL will add this support soon.
Comments
Post a Comment