Create the trigger drop_id before update on Commodity_information for each row. If new id!=id. Then set new id=floor (rand () * 99999999999); End the if;

CodePudding user response:

If the new id!=OLD. Id. Then set new id=floor (rand () * 99999999999); End the if;

CodePudding user response:

What mistake?