useful-qry/function-in-db/triggers/sorder_after_insert-already-.sql

drop trigger if exists sorder_after_insert;
DELIMITER // 
create trigger sorder_after_insert after insert on dbr_sorder
    for each row begin
        if new.reward_amt <> '0.0000' then
            call reward_bd_act('sorder', new.id, 0);
        end if; 
    end //
DELIMITER ;

2022/08/03 05:00:35 [Log]: jfhgkeytg @  DB error in Adding Id of 0 in dbr_sorder Error 1442: Can't update table 'dbr_sorder' in stored function/trigger because it is already used by statement which invoked this stored function/trigger