MySQL database trigger

Here is an example MySQL database trigger

CREATE TRIGGER dbevent AFTER INSERT ON invoice
    FOR EACH ROW 
    BEGIN
    INSERT INTO dbeventtriggertable VALUES (new.accountnumber);
END;

 

 This can be used in the Database Event activity (Develop > Events > Database)

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.