MySQL Trigger Learning

DROP TRIGGER IF EXISTST_a_b;/*Delete Trigger*/CREATE TRIGGERT_a_b/*Create a trigger T_a_b*/ AfterINSERT  onA/*identification trigger time, value is before or after;*/                                 /*Thus, there are 6 types of triggers that can be created: Before insert, before update, before DELETE, after INSERT, after UPDATE,
After DELETE. */ forEach ROWBEGIN                              /*a trigger program body, which can be a SQL statement, or multiple statements with BEGIN and END. */    INSERT  intoB (NAME)/*Table B New name, value is the value of a*/VALUES(new.name);END;INSERT  intoA (NAME)Values("001");DROP TRIGGER IF EXISTSD_a_b;CREATE TRIGGERD_a_bafterDELETE  ona forEach ROWBEGIN DELETE  fromBWHEREName=Old.name;END;DELETE  fromAWHEREName="001";

MySQL Trigger Learning