mysql 不能在一个触发器中进行insert,update,delete操作,需分别建三个触发器
insert触发器:
delimiter $$
create trigger tri_city_insert
after insert
on t_xfw_city
for each row
begin
insert into t_tri_city(id,name,provinceid,ctype)
values(new.id,new.name,new.provinceid,1);
end
update触发器:
delimiter $$
create trigger tri_city_update
after update
on t_xfw_city
for each row
begin
insert into t_tri_city(id,name,provinceid,ctype)
values(new.id,new.name,new.provinceid,2);
end
delete触发器:
delimiter $$
create trigger tri_city_delete
after delete
on t_xfw_city
for each row
begin
insert into t_tri_city(id,name,provinceid,ctype)
values(old.id,old.name,old.provinceid,3);
end
对一个表建三个触发器有些麻烦,不知道还有没有好点的方法