mysql--触发器

#插入前：
create trigger t1_i_b(触发器名) before insert on  info(表名) each row
begin
    ...
end

#插入后
create trigger t1_i_a(触发器名) after insert on  info(表名) each row
begin
    ...
end

#删除前
create trigger t1_d_b(触发器名) before delete on  info(表名) each row
begin
    ...
end

#删除后
create trigger t1_d_a(触发器名) after delete on  info(表名) each row
begin
    ...
end

#更新前
create trigger t1_u_b(触发器名) before update on  info(表名) each row
begin
    ...
end

#更新后
create trigger t1_u_a(触发器名) after update on  info(表名) each row
begin
    ...
end

delimiter //
create trigger t_i_b before insert on info for each row
begin
    if NEW.name == ‘asd‘ then    #if 中 数字使用 = ，字符串使用 ==
       insert into info (name) values(‘aa‘)
   end 
end
delimiter ;