mysql 触发器

1.查看

SHOW TRIGGERS

 2.创建表

CREATE  TABLE `data_trigger_t1` (
  `name` VARCHAR(80) NULL ,
  `pwd` VARCHAR(80) NULL ,
  PRIMARY KEY (`name`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

 表二

CREATE  TABLE `data_trigger_t2` (
  `name` VARCHAR(80) NULL ,
  `pwd` VARCHAR(80) NULL ,
  PRIMARY KEY (`name`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

 3.创建触发器

DELIMITER $$
CREATE TRIGGER insert_to_back after insert on data_trigger_t1
for each row
BEGIN
	insert into data_trigger_t2(name,pwd) values (NEW.name,NEW.pwd);
END$$
DELIMITER ;

当二个表一样时也可以

insert into data_trigger_t2 select * from data_trigger_t1 where name = NEW.name;

 4.测试

insert into data_trigger_t1(name,pwd) values('name1','value1');

select * from data_trigger_t1;
select * from data_trigger_t2;

 5.删除

drop trigger insert_to_back;