mysql简单触发器
mysql通过触发器实现两张插入数据同步
1,新建两张表
2.如下代码(我的两张表是student,student2)
delimiter
CREATE TRIGGER t_student2_insert
after insert on student
for Each row begin
insert into student2(id,name,birthday) values(new.id,new.name,new.birthday);
end ||
delimiter