触发器

delimiter $$

CREATE TRIGGER before_insert_color before INSERT on color for each ROW
BEGIN
insert into man(name) values('mink');
END $$
delimiter ;

insert into color(color_name) values ('ooo')

 

同时插入两条：insert into color(color_name) values ('ooo'),('red2')

删除触发器：drop TRIGGER  if exists   before_insert_color   $$

 NEW/OLD

a.在删除之前插入，OLD

delimiter $$
drop TRIGGER if EXISTS BEFORE_insert_color

CREATE TRIGGER before_insert_color before DELETE on color for each ROW
BEGIN

insert into man(name) values(OLD.title);
end if;
END $$
delimiter ;

delete from color where nid=8;

b.插入前插入

 把插入的参数之前再另一个表也创建对应的数据