本文共 1212 字,大约阅读时间需要 4 分钟。
SQL因外键影响而删除失败的一个解决办法
create table a ( id varchar(8), primary key(id) ); create table b ( id varchar(8), name varchar(6), foreign key(id) references a(id), primary key(id) ); insert into a values('1202'); insert into a values('2320'); insert into a values('1981'); insert into a values('4390'); insert into b values('1202','alice'); insert into b values('2320','carlos'); insert into b values('1981','dem'); insert into b values('4390','ema');
select *into cfrom b;
insert into c select * from b where not exists( select * from c where c.id=b.id and c.name=b.name );--对c表进行更新,即插入b表有而c表没有的数据
转载地址:http://cqvgn.baihongyu.com/