DELIMITER // CREATE TRIGGER credit_bd_insert AFTER INSERT ON dbr_credit_bd FOR EACH ROW SQL SECURITY INVOKER BEGIN UPDATE dbr_company SET curr_credit_bal = new.bal_amt WHERE id = new.buyer_id; END// DELIMITER ;
