mysql--Trigger

Trigger an action when a table is being hacked with a trigger

1. Basic statement (also need to modify delimiter)

#插入前: Create Trigger T1_i_b (trigger name) before insert on  info (table name) each rowbegin    ... end# insert create TRIGGER t1_i_a (trigger name) After insert on  info (table name) each rowbegin ...    end# before delete create trigger T1_d_b (trigger name) before delete on  info (table name) each R Owbegin.    end# After delete create trigger t1_d_a (trigger name) after delete on  info (table name) each Rowbegin    ... end# before update create Trigger T1_u_b (trigger name) before update on  info (table name) each Rowbegin    ... end# after update create TRIGGER t1_u_a (trigger name) after update On  info (table name) each rowbegin ...    end

Note: New represents the data row that will be inserted, and old indicates the data row to be deleted.

//  for Each rowbegin     if ' ASD ' then    #if the number using =, the string uses = =       INSERT into info (name) VALUES ('aa'  )   end Enddelimiter;

mysql--Trigger