Definition of MySQL Trigger

--InsertDELIMITER $$ Use' testdatabase ' $$DROP TRIGGER /*!50032 IF EXISTS*/' Trigger_xxx_insert ' $$CREATE    /*!50017 definer = ' root ' @ '% '*/    TRIGGER' Trigger_xxx_insert ' afterINSERT  on' tb_xxx ' forEach ROWBEGIN    DECLARENewStatusINT; SETNewStatus=NEW ' Status '; --omit do something    END; $ $DELIMITER;--UpdateDELIMITER $$ Use' testdatabase ' $$DROP TRIGGER /*!50032 IF EXISTS*/' trigger_xxx_update ' $$CREATE    /*!50017 definer = ' root ' @ '% '*/    TRIGGER' Trigger_xxx_update ' beforeUPDATE  on' tb_xxx ' forEach ROWBEGIN    DECLAREOldstatusINT; DECLARENewStatusINT; SETOldstatus=Old . ' Consultationstatus '; SETNewStatus=NEW ' Consultationstatus '; IF(NewStatus<>oldstatus) Then         --continue do something    END IF; END; $ $DELIMITER;

Definition of MySQL Trigger