1:用触发器
2:
级联更新和级联删除:alter table mylocation
add constraint fk_mylocation_myname foreign key(myname) references myname(name)
on update cascade on delete cascade
alter table 表2
add constraint fk_mylocation_myname foreign key(字段1,字段2)references 表1(字段1,字段2)
on update cascade on delete cascade
2:
级联更新和级联删除:alter table mylocation
add constraint fk_mylocation_myname foreign key(myname) references myname(name)
on update cascade on delete cascade
alter table 表2
add constraint fk_mylocation_myname foreign key(字段1,字段2)references 表1(字段1,字段2)
on update cascade on delete cascade
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货